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

From Bruce Momjian
Subject Re: Clustering system catalog indexes
Date
Msg-id 200405200258.i4K2wpd20987@candle.pha.pa.us
Whole thread Raw
In response to Re: Clustering system catalog indexes  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Christopher Kings-Lynne wrote:
> > 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...

Yes, but that cache has to be loaded sometime.

--  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 by date:

Previous
From: pgsql@mohawksoft.com
Date:
Subject: Re: Table Spaces
Next
From: Bruce Momjian
Date:
Subject: Re: Clustering system catalog indexes