Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Alfred PerlsteinDate: 2000-05-26 22:14:49
Subject: Re: Performance issue 6.5 versus 7.0
Previous:From: Herbert LiechtiDate: 2000-05-26 22:09:09
Subject: Re: Performance issue 6.5 versus 7.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group