Re: Update Performance from 6.5.0 to 6.5.3 to 7.0

From: Alfred Perlstein <bright(at)wintelcom(dot)net>
To: Bryan White <bryan(at)arcamax(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Update Performance from 6.5.0 to 6.5.3 to 7.0
Date: 2000-05-26 22:14:00
Message-ID: 20000526151359.C28594@fw.wintelcom.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Bryan White <bryan(at)arcamax(dot)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(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alfred Perlstein 2000-05-26 22:14:49 Re: Performance issue 6.5 versus 7.0
Previous Message Herbert Liechti 2000-05-26 22:09:09 Re: Performance issue 6.5 versus 7.0