[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] pg_dump and XID limit
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2010-11-24 15:16:48
Message-ID: 18330.1290611808 () sss ! pgh ! pa ! us
[Download RAW message or body]

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 much of 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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[prev in list] [next in list] [prev in thread] [next in thread]