Bruce Momjian escribió: > Simon Riggs wrote: > > On Thu, 2007-03-01 at 22:35 +0530, Pavan Deolasee wrote: > > > Merlin Moncure wrote: > > > > On 3/1/07, Pavan Deolasee <[EMAIL PROTECTED]> wrote: > > > >> > > > > seems pretty solid except for one possible problem...at one point when > > > > I dropped then later added the index on 'abalance', I got spammed > > > > 'WARNING: found a HOT-updated tuple' from psql prompt. > > > > > > Thats intentional. We don't yet support CREATE INDEX on a HOT-updated > > > table. This is one of the major unfinished TODO items before we can > > > consider patch feature complete. I have left the warning to catch > > > this case till then. > > > > CREATE INDEX and VACUUM FULL will require changes. Proposals for VACUUM > > FULL have been posted, CREATE INDEX should be there tomorrow. > > > > CLUSTER does not need changes for HOT, as things stand currently, mainly > > because its MVCC behaviour is broken. > ------------------------ > > That's oddly discouraging. :-)
Apparently no one has been bothered enough to fix CLUSTER. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly