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

From Joshua D. Drake
Subject Re: MVCC, undo log, and HOT
Date
Msg-id 471C0791.40801@commandprompt.com
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 Momjian wrote:
>> Those who have been with the community from long ago might remember
>> discussion about implementing a undo log.  The big advantage of this is
>> that it allows UPDATE to _replace_ rows and limits the amount of cleanup
>> required for UPDATEs.
>>
>> I am hoping that with HOT we will no longer have any need to even
>> consider undo.
>>
> 
> We were considering it?

I don't ever remember us considering it seriously.

> 
> I certainly wasn't.  I've enough experience with Oracle and InnoDB to 
> see that an undo log is its own set of performane issues.   No thanks.
> 

It certainly does.

Joshua D. Drake


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Ready for beta2?
Next
From: Tom Lane
Date:
Subject: Rethinking ts_debug() output