Re: CLUSTER and a problem - Mailing list pgsql-performance

From Grzegorz Jaśkiewicz
Subject Re: CLUSTER and a problem
Date
Msg-id 2f4958ff0909160234w490b7e44ud46b29482ec46b54@mail.gmail.com
Whole thread Raw
In response to Re: CLUSTER and a problem  (Andrzej Zawadzki <zawadaa@wp.pl>)
List pgsql-performance
On Tue, Sep 15, 2009 at 9:10 PM, Andrzej Zawadzki <zawadaa@wp.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.



--
GJ

pgsql-performance by date:

Previous
From: Andrzej Zawadzki
Date:
Subject: Re: CLUSTER and a problem
Next
From: "Vlad Romascanu"
Date:
Subject: Possible causes of sometimes slow single-row UPDATE with trivial indexed condition?