CLUSTER all tables at once?

From: Alvaro Herrera <alvherre(at)atentus(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: CLUSTER all tables at once?
Date: 2002-08-12 20:50:56
Message-ID: Pine.LNX.4.44.0208121643440.11085-100000@cm-lcon1-46-187.cm.vtr.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2002-08-12 20:51:41 Oracle releasing clustered file system code
Previous Message Peter Eisentraut 2002-08-12 20:07:18 Re: [GENERAL] Linux Largefile Support In Postgresql RPMS