Re: Clustering system catalog indexes

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Clustering system catalog indexes
Дата
Msg-id 200405200143.i4K1hMe09781@candle.pha.pa.us
обсуждение исходный текст
Ответ на Clustering system catalog indexes  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Ответы Re: Clustering system catalog indexes
Re: Clustering system catalog indexes
Список pgsql-hackers
Christopher Kings-Lynne wrote:
> Is it worth us marking any system catalog indexes as clusterable by 
> default for performance?

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.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_type oid's do they change from version to version
Следующее
От: Gavin Sherry
Дата:
Сообщение: Re: Table Spaces