Re: Plans for solving the VACUUM problem - Mailing list pgsql-hackers

From Lincoln Yeoh
Subject Re: Plans for solving the VACUUM problem
Date
Msg-id 3.0.5.32.20010521092806.01069d40@192.228.128.13
Whole thread Raw
In response to Re: Plans for solving the VACUUM problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
At 01:09 PM 20-05-2001 -0400, Tom Lane wrote:
>>> 3. Reusing xact IDs would be nice, but there's an answer with a lot less
>>> impact on the system: go to 8-byte xact IDs.
>
>> +8 bytes in tuple header is not so tiny thing.
>
>Agreed, but the people who need 8-byte IDs are not running small
>installations.  I think they'd sooner pay a little more in disk space
>than risk costs in performance or reliability.

An additional 4 (8?) bytes per tuple to increase the "mean time before
problem " 4 billion times sounds good to me.

Cheerio,
Link.



pgsql-hackers by date:

Previous
From: mlw
Date:
Subject: Index and functions
Next
From: "Christopher Kings-Lynne"
Date:
Subject: RE: Updating system catalogs after a tuple deletion