Skip site navigation (1) Skip section navigation (2)

Re: HOT - preliminary results

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Pavan Deolasee <pavan(dot)deolasee(at)enterprisedb(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: HOT - preliminary results
Date: 2007-03-02 22:49:49
Message-ID: 20070302224949.GB14953@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2007-03-02 22:58:19
Subject: Re: Removing some of the old VC++ stuff
Previous:From: Bruce MomjianDate: 2007-03-02 22:46:40
Subject: Re: [HACKERS] Deadlock with pg_dump?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group