Re: Minimally avoiding Transaction Wraparound in VLDBs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Minimally avoiding Transaction Wraparound in VLDBs
Date
Msg-id 12257.1125581735@sss.pgh.pa.us
Whole thread Raw
In response to Re: Minimally avoiding Transaction Wraparound in VLDBs  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> So, will per-table XID tracking allow us to avoid *ever* vacuuming some  
> tables?

If your definition of "ever" is less than a billion transactions, sure.
(As Simon points out, with time-partitioned data sets that could often
be arranged, so it's not a completely silly response.)

> If not, what could?

The only possibility for more-than-a-billion is widening XIDs to 64
bits, which would come with its own set of performance penalties.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Minimally avoiding Transaction Wraparound in VLDBs
Next
From: Alvaro Herrera
Date:
Subject: Re: Remove xmin and cmin from frozen tuples