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

From Alfred Perlstein
Subject Re: Update Performance from 6.5.0 to 6.5.3 to 7.0
Date
Msg-id 20000526160144.E28594@fw.wintelcom.net
Whole thread Raw
In response to Re: Update Performance from 6.5.0 to 6.5.3 to 7.0  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
* Tom Lane <tgl@sss.pgh.pa.us> [000526 15:43] wrote:
> "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?

I'm quite sure we experianced the same problem (mutliple indexes causing
slow update/inserts) when we moved an identical table structure from
6.5 to 7.0

-Alfred

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance issue 6.5 versus 7.0
Next
From: Tom Lane
Date:
Subject: Re: Speed of locating tables?