Re: Clustering system catalog indexes - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Clustering system catalog indexes
Date
Msg-id 20040520020217.GA13544@dcc.uchile.cl
Whole thread Raw
In response to Re: Clustering system catalog indexes  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Clustering system catalog indexes  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: Gavin Sherry
Date:
Subject: Re: Table Spaces
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Clustering system catalog indexes