Re: CLUSTER all tables at once?

From: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Alvaro Herrera" <alvherre(at)atentus(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CLUSTER all tables at once?
Date: 2002-08-14 12:07:01
Message-ID: 46C15C39FEB2C44BA555E356FBCD6FA4961E48@m0114.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2002-08-14 12:08:46 Re: Open 7.3 items
Previous Message Rod Taylor 2002-08-14 11:55:52 Re: Domains and Indexes