Re: MVCC, undo log, and HOT - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: MVCC, undo log, and HOT
Date
Msg-id 200710230412.l9N4CIK13921@momjian.us
Whole thread Raw
In response to Re: MVCC, undo log, and HOT  (Josh Berkus <josh@agliodbs.com>)
Responses Re: MVCC, undo log, and HOT
List pgsql-hackers
Josh Berkus wrote:
> Bruce,
> 
> > We never actually considred undo, but high UPDATE activity was one of
> > the areas we historically handled poorly compared to undo systems, and
> > undo would have been one way to improve that area.  I think with HOT we
> > have improved high UPDATE activity enough that the undo benefits are no
> > longer attractive (and of course the undo disadvantages were never
> > attractive).
> > 
> 
> If you're asking if we should remove the TODO (is there one?) and 
> replace it with a FAQ item called "Why PostgreSQL doesn't have an UNDO 
> LOG", then my vote is "yes".

No, it never got close to being a TODO item.  It was more a limitation
we had that is now fixed.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Feature Freeze date for 8.4
Next
From: Andrew Dunstan
Date:
Subject: Re: MVCC, undo log, and HOT