Re: Outstanding patches

Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> On Thu, Nov 07, 2002 at 12:27:05AM -0500, Tom Lane wrote:
>> CLUSTER ALL patch: I have a problem with this, specifically the fact
>> that it changes CLUSTER into a multi-transaction operation.

> That was your suggestion...

Well, it'd be okay (IMHO anyway) if it only happened for CLUSTER ALL.
You've built it in a way that the restriction applies to single-table
CLUSTERs, which is an unnecessary step backwards.

What I think I'd like to see is
CLUSTER index ON table    -- does not hack transactionsCLUSTER table -- recluster a table, does not hack
transactionsCLUSTER-- recluster all tables, works like VACUUM
 

This would allow people to build functions that do selective CLUSTERing,
at the price of holding more exclusive locks.
        regards, tom lane