Re: GetOldestXmin going backwards is dangerous after all - Mailing list pgsql-hackers

From Tom Lane
Subject Re: GetOldestXmin going backwards is dangerous after all
Date
Msg-id 566.1359996725@sss.pgh.pa.us
Whole thread Raw
In response to Re: GetOldestXmin going backwards is dangerous after all  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: GetOldestXmin going backwards is dangerous after all  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes:
> I absolutely hate to suggest it, but what about storing the last
> vacuum's xmin horizon in the main table's pg_class.options in the back
> branches?

Not workable.  This would require a non-in-place update of the table's
pg_class row (at least in cases where the option wasn't stored already).
Which would require VACUUM to have an XID, which would make a whole lot
of assumptions fall over.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: GetOldestXmin going backwards is dangerous after all
Next
From: Dimitri Fontaine
Date:
Subject: Re: sql_drop Event Trigger