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 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

Re: [PERFORM] Process Time X200

2006-03-10 Thread NbForYou
: 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 webhost we

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

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 he do

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 NbForYou
, 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

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

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 the use

[PERFORM] Process Time X200

2006-03-09 Thread NbForYou
Hello, I could need some help. I have a Postgresql databaseWhen 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 just a