On Tue, Sep 15, 2009 at 9:10 PM, Andrzej Zawadzki <zawadaa(at)wp(dot)pl> wrote:
> So, I was close - bad index... DESCending is much better.
> Thanks to Grzegorz Ja\skiewicz hi has strengthened me in the conjecture.
> I'm posting this - maybe someone will find something useful in that case.
> ps. query was and is good :-)
Sure, This was talked about a lot on -hackers. The cost of 'back-walk'
index fetch is a lot.
So for anyone who thought it isn't back then, well - here's real life proof.
In response to
pgsql-performance by date
|Next:||From: Richard Huxton||Date: 2009-09-17 07:58:35|
|Subject: Re: Possible causes of sometimes slow single-row UPDATE
with trivial indexed condition?|
|Previous:||From: Andrzej Zawadzki||Date: 2009-09-15 20:10:49|
|Subject: Re: CLUSTER and a problem|