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

From Tom Lane
Subject Re: Update Performance from 6.5.0 to 6.5.3 to 7.0
Date
Msg-id 3738.959378084@sss.pgh.pa.us
Whole thread Raw
In response to Re: 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>)
List pgsql-general
"Bryan White" <bryan@arcamax.com> writes:
>>>> 4, I could probably get by with just 2 If I had to.  I will give it a
>>>> try.

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

That's good, but does it mean that 7.0 is slower about adding index
entries than 6.5 was?  Or did you have fewer indexes on the table
when you were using 6.5?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Speed of locating tables?
Next
From: Tom Lane
Date:
Subject: Re: INSERT/UPDATE in views fail silently