Re: Clustering system catalog indexes

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Clustering system catalog indexes
Дата
Msg-id 40AC1371.1010609@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: Clustering system catalog indexes  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Clustering system catalog indexes
Список pgsql-hackers
> Not sure. Most of the system stuff is loaded in a pretty good order, and
> cluster is only good if you are going after seveal rows of identical
> value or similar value in the same table, and I can't think of a case
> where this would help.  Can others?  It is a good question.

pg_attribute would commonly be fetched via the attrelid.  However, I 
guess it's all cached anyway...

Chris


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Clustering system catalog indexes
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: alter table alter columns vs. domains