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

From Rod Taylor
Subject Re: CLUSTER all tables at once?
Date
Msg-id 1029185939.42569.102.camel@jester
Whole thread Raw
In response to CLUSTER all tables at once?  (Alvaro Herrera <alvherre@atentus.com>)
List pgsql-hackers
> Maybe if some index had the indisclustered bit set one could select
> that; but is it possible for some table to have more than one index with
> it?  Intuition (but no code observation) says no.  And what happens with
> those tables that do not have any such index?

The bool marker sounds useful.  Falling back on the primary key is
probably the most appropriate.



pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Oracle releasing clustered file system code
Next
From: Joe Conway
Date:
Subject: Re: [GENERAL] workaround for lack of REPLACE() function