Tom Lane escribió: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Note that while reordering, CLUSTER also gets rid of dead tuples, so if > > you cluster you don't need to vacuum. > > Just for the record, that behavior is seriously broken: it violates > MVCC if any of the deleted tuples are still visible to anyone else.
Well, FWIW, the fact that the CLUSTER command exists at all is broken IMHO ... but meanwhile, are you suggesting that CLUSTER should be fixed to retain tuples that are visible to running transactions? -- 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
