On Tue, Sep 15, 2009 at 9:10 PM, Andrzej Zawadzki <zawadaa@xxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
