Re: Clustering system catalog indexes

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Clustering system catalog indexes
Дата
Msg-id 20040520020217.GA13544@dcc.uchile.cl
обсуждение исходный текст
Ответ на Re: Clustering system catalog indexes  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Clustering system catalog indexes
Список pgsql-hackers
On Wed, May 19, 2004 at 09:43:22PM -0400, Bruce Momjian wrote:
> 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.

pg_attribute maybe?

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Cómo ponemos nuestros dedos en la arcilla del otro. Eso es la amistad; jugar
al alfarero y ver qué formas se pueden sacar del otro" (C. Halloway en
La Feria de las Tinieblas, R. Bradbury)


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

Предыдущее
От: Gavin Sherry
Дата:
Сообщение: Re: Table Spaces
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Clustering system catalog indexes