Re: [PERFORM] Process Time X200

2006-03-14 Thread Jim C. Nasby
On Fri, Mar 10, 2006 at 10:46:56AM -0600, Scott Marlowe wrote: > I think it's time to get a new hosting provider. > > If they're still running PostgreSQL 7.3.9 (the latest 7.3 is 7.3.14, and > 8.1.3 is amazingly faster than 7.3.anything...) then they're likely not > updating other vital components

Re: [PERFORM] Process Time X200

2006-03-10 Thread Scott Marlowe
On Fri, 2006-03-10 at 04:45, NbForYou wrote: > Ok, Everybody keeps saying that Postgresql is free... > > So I contacted my webhost and their respons was they have to pay a license > fee. > > But because they use PLESK as a service I think they are refering to a fee > PLESK charges them > for th

Re: [PERFORM] Process Time X200

2006-03-10 Thread Matthew Nuzum
On 3/10/06, NbForYou <[EMAIL PROTECTED]> wrote: > Hey Michael, you sure know your stuff! > > Versions: > > PostgreSQL 7.3.9-RH running on the webhost. > PostgreSQL 8.0.3 running on my homeserver. > > So the only solution is to ask my webhost to upgrade its postgresql? > The question is will he do t

Re: [PERFORM] Process Time X200

2006-03-10 Thread PFC
Ok, Everybody keeps saying that Postgresql is free... So I contacted my webhost and their respons was they have to pay a license fee. But because they use PLESK as a service I think they are refering to a fee PLESK charges them for the use combination PLESK - POSTGRESQL Probab

Re: [PERFORM] Process Time X200

2006-03-10 Thread NbForYou
ch 10, 2006 10:40 AM Subject: Re: [PERFORM] Process Time X200 NbForYou wrote: Hey Michael, you sure know your stuff! Versions: PostgreSQL 7.3.9-RH running on the webhost. PostgreSQL 8.0.3 running on my homeserver. So the only solution is to ask my webhost to upgrade its postgresql? The question i

Re: [PERFORM] Process Time X200

2006-03-10 Thread Richard Huxton
NbForYou wrote: Hey Michael, you sure know your stuff! Versions: PostgreSQL 7.3.9-RH running on the webhost. PostgreSQL 8.0.3 running on my homeserver. So the only solution is to ask my webhost to upgrade its postgresql? The question is will he do that? After all a license fee is required for

Re: [PERFORM] Process Time X200

2006-03-10 Thread Ragnar
On fös, 2006-03-10 at 10:11 +0100, NbForYou wrote: > Hey Michael, you sure know your stuff! > > Versions: > > PostgreSQL 7.3.9-RH running on the webhost. > PostgreSQL 8.0.3 running on my homeserver. > > So the only solution is to ask my webhost to upgrade its postgresql? > The question is will h

Re: [PERFORM] Process Time X200

2006-03-10 Thread Guido Neitzer
On 10.03.2006, at 10:11 Uhr, NbForYou wrote: So the only solution is to ask my webhost to upgrade its postgresql? Seems to be. The question is will he do that? You are the customer. If they don't, go to another provider. After all a license fee is required for commercial use. And running

Re: [PERFORM] Process Time X200

2006-03-10 Thread NbForYou
c: Sent: Friday, March 10, 2006 9:59 AM Subject: Re: [PERFORM] Process Time X200 On Fri, Mar 10, 2006 at 08:11:44AM +0100, NbForYou wrote: As you can see the query isn't useful anymore because of the processtime. Please Also notice that both systems use a different query plan. Also on the

Re: [PERFORM] Process Time X200

2006-03-10 Thread Michael Fuhr
On Fri, Mar 10, 2006 at 08:11:44AM +0100, NbForYou wrote: > As you can see the query isn't useful anymore because of the > processtime. Please Also notice that both systems use a different > query plan. > Also on the webhost we have a loop of 162409 (403 rows * 403 rows). > Both systems also use a

[PERFORM] Process Time X200

2006-03-09 Thread NbForYou
Hello,   I could need some help.    I have a Postgresql database When i do a query on my homeserver the result is given back fast but when i do the same query on my webhost server the query is useless because of the processtime (200 times slower  (56366.20 / 281.000 = 200.59) ). My Pc is ju