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

From Christopher Kings-Lynne
Subject Re: Clustering system catalog indexes
Date
Msg-id 40AC1371.1010609@familyhealth.com.au
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
> 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Clustering system catalog indexes
Next
From: Bruce Momjian
Date:
Subject: Re: alter table alter columns vs. domains