Postgres Pro
Downloads
Home   >   mailing lists

Re: Update Performance from 6.5.0 to 6.5.3 to 7.0 - Mailing list pgsql-general

From Bryan White
Subject Re: Update Performance from 6.5.0 to 6.5.3 to 7.0
Date
Msg-id 016801bfc74f$2ba2da20$2dd260d1@arcamax.com
Whole thread Raw
In response to Update Performance from 6.5.0 to 6.5.3 to 7.0  ("Bryan White" <bryan@arcamax.com>)
Responses Re: Update Performance from 6.5.0 to 6.5.3 to 7.0  (Alfred Perlstein <bright@wintelcom.net>)
Re: Update Performance from 6.5.0 to 6.5.3 to 7.0  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
> > 4, I could probably get by with just 2 If I had to.  I will give it a
try.
>
> yes! this should fix it for you.

With the indexes deleted I am now getting 40 or 50 updates per second
instead of 5.

Thanks alot.

pgsql-general by date:

Previous
From: Herbert Liechti
Date:
Subject: Performance issue 6.5 versus 7.0
Next
From: Alfred Perlstein
Date:
Subject: Re: Performance issue 6.5 versus 7.0