Re: Deferring transaction wraparound - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Deferring transaction wraparound
Date
Msg-id CA+U5nMJ3koWBpm2QBu4DLLuM97yPY=ghqcBDg1tQ0-MFM6U5oQ@mail.gmail.com
Whole thread Raw
In response to Deferring transaction wraparound  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On 1 June 2013 09:22, Simon Riggs <simon@2ndquadrant.com> wrote:

> A much better idea is to hold the xmin epoch on the tuple, in addition
> to the xid, if there was a good place to hold this.

This idea is an almost exact duplicate of Heikki Linnakangas' idea for
exactly the same problem.

Given Robert Haas' idea to use the page LSN to indicate the epoch last
changes were made, it allows us to do pretty much this idea in a
slightly easier way.

So this idea withdrawn as a proposal, assuming we can go ahead with
the above mentioned approach.

--Simon Riggs                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Optimising Foreign Key checks
Next
From: Cédric Villemain
Date:
Subject: Re: PostgreSQL 9.3 beta breaks some extensions "make install"