Re: strategies for optimizing read on rather large tables

Поиск
Список
Период
Сортировка
От hubert lubaczewski
Тема Re: strategies for optimizing read on rather large tables
Дата
Msg-id 20050604121319.GA25309@eo.pl
обсуждение исходный текст
Ответ на Re: strategies for optimizing read on rather large tables  (PFC <lists@boutiquenumerique.com>)
Список pgsql-performance
On Sat, Jun 04, 2005 at 02:07:52PM +0200, PFC wrote:
>     don't forget to mention all the index columns in the order by, or
>     the  planner won't use it.

of course.
i understand the concept. actually i find kind of ashamed i did not try
it before.
anyway - thanks for great tip.

depesz

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: PFC
Дата:
Сообщение: Re: strategies for optimizing read on rather large tables
Следующее
От: "Bernd Jagla"
Дата:
Сообщение: Best hardware