Re: CLUSTER all tables at once?

From: Rod Taylor <rbt(at)zort(dot)ca>
To: Alvaro Herrera <alvherre(at)atentus(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CLUSTER all tables at once?
Date: 2002-08-12 20:58:57
Message-ID: 1029185939.42569.102.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2002-08-12 21:55:54 Re: [GENERAL] workaround for lack of REPLACE() function
Previous Message Joe Conway 2002-08-12 20:51:41 Oracle releasing clustered file system code