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

From Jonah H. Harris
Subject Re: MVCC, undo log, and HOT
Date
Msg-id 36e682920710230613j5a4b6dbata786271a139666b0@mail.gmail.com
Whole thread Raw
In response to Re: MVCC, undo log, and HOT  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
On 10/23/07, Simon Riggs <simon@2ndquadrant.com> wrote:
> > We never actually considred undo
>
> I did, but eventually ruled it out during the HOT design process. But
> then I considered a ton of other things and ruled them out also.
>
> Can't see a reason to bring it up again, so perhaps we should add it to
> the definitely don't want list. Don't *need* would be better.

Actually, my initial UNDO design and prototype had several other
advantages over HOT (better performance, inherent time-travel, smaller
on-disk footprint, and *no* vacuum).  The major issue was due to the
amount of architecture changes Postgres would've required and Bruce's
advice regarding the community's inability to accept such a large and
complex change.

-- 
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation                | fax: 732.331.1301
499 Thornall Street, 2nd Floor          | jonah.harris@enterprisedb.com
Edison, NJ 08837                        | http://www.enterprisedb.com/


pgsql-hackers by date:

Previous
From: "Gokulakannan Somasundaram"
Date:
Subject: Re: [PATCHES] Including Snapshot Info with Indexes
Next
From: "Jonah H. Harris"
Date:
Subject: Re: MVCC, undo log, and HOT