Re: Transaction ID wraparound: problem and proposed solution

From: Mark Hollomon <mhh(at)mindspring(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Transaction ID wraparound: problem and proposed solution
Date: 2000-11-06 18:09:19
Message-ID: 00110613091900.00324@jupiter
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sunday 05 November 2000 13:02, Tom Lane wrote:
> OK, 2^64 isn't mathematically unbounded, but let's see you buy a disk
> that will hold it ;-). My point is that if we want to think about
> allowing >4G transactions, part of the answer has to be a way to recycle
> pg_log space. Otherwise it's still not really practical.

I kind of like vadim's idea of segmenting pg_log.

Segments in which all the xacts have been commited could be deleted.

--
Mark Hollomon

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-11-06 18:17:28 Horology regress test changed?
Previous Message Ross J. Reedstrom 2000-11-06 17:40:47 Re: Alternative database locations are broken