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

From Tom Lane
Subject Re: ALTER TABLE TODO items
Date
Msg-id 1293.1083862319@sss.pgh.pa.us
Whole thread Raw
In response to Re: ALTER TABLE TODO items  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: ALTER TABLE TODO items  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: sdv mailer
Date:
Subject: Re: PostgreSQL pre-fork speedup
Next
From: Thomas Swan
Date:
Subject: Re: PostgreSQL pre-fork speedup