Re: CLUSTER and a problem

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема Re: CLUSTER and a problem
Дата
Msg-id 2f4958ff0909160234w490b7e44ud46b29482ec46b54@mail.gmail.com
обсуждение исходный текст
Ответ на Re: CLUSTER and a problem  (Andrzej Zawadzki <zawadaa@wp.pl>)
Список 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 по дате отправления:

Предыдущее
От: Andrzej Zawadzki
Дата:
Сообщение: Re: CLUSTER and a problem
Следующее
От: "Vlad Romascanu"
Дата:
Сообщение: Possible causes of sometimes slow single-row UPDATE with trivial indexed condition?