Re: pg_restore and transaction id wraparound

Christopher Browne <cbbrowne@acm.org> writes:
> - If you type in BEGIN;, then you could have 10 billion SQL
>   statements after that, and they would, altogether, consume 1 xid.

Actually you can only have 4 billion SQL commands per xid, because the
CommandId datatype is also just 32 bits.  I've never heard of anyone
running into that limit, though.

            regards, tom lane