Re: ALTER TABLE TODO items - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: ALTER TABLE TODO items
Date
Msg-id 200405061656.i46Gud810900@candle.pha.pa.us
Whole thread Raw
In response to Re: ALTER TABLE TODO items  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > At a minimum, we should indicate we dropped the cluster on the index.
> 
> [shrug] If you're going to make me do that, I might as well reinstall
> the bit on the new index.  The code's problem is it doesn't know that
> any of the indexes it dropped were clustered, and finding that out is
> 90% of the issue.
> 
> What I want to know is whether it is sensible to mark the revised index
> as clustered, given that its semantics might be significantly different
> from before.

OK, yea, just leave the bit.  We can add documentation that they should
run CLUSTER again if they radically modified the column as part of the
ALTER>

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Thomas Swan
Date:
Subject: Re: PostgreSQL pre-fork speedup
Next
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL pre-fork speedup