Re: pg_dump and XID limit - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump and XID limit
Date
Msg-id 18330.1290611808@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump and XID limit  (Elliot Chance <elliotchance@gmail.com>)
List pgsql-admin
Elliot Chance <elliotchance@gmail.com> writes:
> Wouldn't that mean at some point it would be advisable to be using 64bit transaction IDs? Or would that change too
muchof the codebase? 

It's not so much "too much of the codebase" as "nobody wants another 8
bytes added to per-row overhead".  Holding a transaction open for
circa 2G transactions would be disastrous anyway, because of table bloat
from inability to reclaim dead rows.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: pg_dump and XID limit
Next
From: James Cloos
Date:
Subject: Re: binary logs: a location other than pg_xlog??