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 по дате отправления: