Re: cluster index on a table

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: cluster index on a table
Дата
Msg-id 4A6051DC0200002500028912@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: cluster index on a table  (Scara Maccai <m_lists@yahoo.it>)
Список pgsql-performance
Scara Maccai <m_lists@yahoo.it> wrote:

>> Be sure to include an ORDER BY clause.

> Isn't it going to be much slower?

It might be; you'd have to test to know for sure.

> The important thing is that most of the records are stored "close"
> enough one to the other in the right order.

Then, yeah, it might not be worth the cost of sorting.

-Kevin

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

Предыдущее
От: Scara Maccai
Дата:
Сообщение: Re: cluster index on a table
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Calling conventions