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 20000526151359.C28594@fw.wintelcom.net
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>)
List pgsql-general
* Bryan White <bryan@arcamax.com> [000526 13:59] wrote:
> > > 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.

It concerns me that with 6.5 this sort of operation with multiple indecies
was fine and now it's slow.

Can anyone explain it?

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

pgsql-general by date:

Previous
From: b.saunders@mindspring.com
Date:
Subject: Failed regression tests
Next
From: Alfred Perlstein
Date:
Subject: Re: Performance issue 6.5 versus 7.0