Re: CLUSTER and clustered indices

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: CLUSTER and clustered indices
Дата
Msg-id 26552.1132243110@sss.pgh.pa.us
обсуждение исходный текст
Ответ на CLUSTER and clustered indices  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: CLUSTER and clustered indices  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> When a table has been CLUSTERed on a particular index AND that index
> values is monotonically increasing, then it would be a bad move to use
> blocks from the FSM since this would tend to destroy the natural
> clustering sequence.

By the time there are any blocks in FSM to take, the original clean
index page sequence is doubtless history.  The pure-increasing-key
scenario you are thinking of never will have any FSM entries, so it's
moot.
        regards, tom lane


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

Предыдущее
От: "Michael Paesold"
Дата:
Сообщение: Re: Optional postgres database not so optional in 8.1
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: CLUSTER and clustered indices