Re: CLUSTER all tables at once? - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: CLUSTER all tables at once?
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA4961E48@m0114.s-mxs.net
Whole thread Raw
In response to CLUSTER all tables at once?  (Alvaro Herrera <alvherre@atentus.com>)
Responses Re: CLUSTER all tables at once?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
> Added to TODO:
>
>     o Cluster all tables at once using pg_index.indisclustered or primary key
>
> > > And what happens with those tables that do not have any such index?
> >
> > Nothing, would be my vote.  You'd just re-CLUSTER all tables that have
> > been clustered before, the same way they were last clustered.

I second Tom's opinion. If the table was not clustered before leave it as is.

Thus the TODO should imho (if at all :-) read:o Cluster all tables at once that have a pg_index.indisclustered

Andreas


pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Domains and Indexes
Next
From: Rod Taylor
Date:
Subject: Re: Open 7.3 items