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

From Alvaro Herrera
Subject CLUSTER all tables at once?
Date
Msg-id Pine.LNX.4.44.0208121643440.11085-100000@cm-lcon1-46-187.cm.vtr.net
Whole thread Raw
Responses Re: CLUSTER all tables at once?  (Rod Taylor <rbt@zort.ca>)
Re: CLUSTER all tables at once?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hello

In TODO there is an item that says "cluster all tables at once".  Might
I ask, how is the system supposed to know on which indexes does it have
to cluster each table?

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?

-- 
Alvaro Herrera (<alvherre[a]atentus.com>)
"Oh, great altar of passive entertainment, bestow upon me thy discordant images
at such speed as to render linear thought impossible" (Calvin a la TV)



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] Linux Largefile Support In Postgresql RPMS
Next
From: Joe Conway
Date:
Subject: Oracle releasing clustered file system code