Simon Riggs escribió: > On Fri, 2007-03-02 at 18:37 -0300, Alvaro Herrera wrote: > > Bruce Momjian escribió: > > > Simon Riggs wrote: > > > > 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. > > We learned from Csaba just the other day that this is a backdoor used on > production systems. I've not seen anyone admit it before, even though > I've seen it discussed.
Yeah, I had just read that and was about to mention it, but I think (some of?) these cases would be solved by HOT. So that usage of CLUSTER would go away altogether, allowing us to fix the MVCC issue ... which would require HOT to work nicely :-( -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
