Re: Loss of cluster status - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Loss of cluster status
Date
Msg-id 0cb201c2dbb4$ec9a5a10$6500a8c0@fhp.internal
Whole thread Raw
In response to Loss of cluster status  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
> > Maybe we should issue it after the CREATE INDEX and ADD CONSTRAINT has
> > occurred and just bite it.
>
> The real problem I think is that we've confused the notion of setting a
> policy for CLUSTER (ie, marking the preferred thing to cluster on) with
> the notion of actually doing a CLUSTER.  Perhaps we need an ALTER
> command that says "this is what to cluster on" without actually doing
> it.

Hmmm...I don't know if I can be bothered working on that - anyone else want
to do it?

> > Other potential problem - ALTER TABLE / SET STORAGE ?
>
> Yeah, pg_dump should be dumping that too, probably.

I'll do a patch for that then.

Chris




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Loss of cluster status
Next
From: Tom Lane
Date:
Subject: Re: ILIKE