Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore and transaction id wraparound - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_restore and transaction id wraparound
Date
Msg-id 8535.1070134149@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_restore and transaction id wraparound  (Christopher Browne <cbbrowne@acm.org>)
Responses Re: pg_restore and transaction id wraparound  (ow <oneway_111@yahoo.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Misplaced modifier in Postgresql license
Next
From: ow
Date:
Subject: Re: pg_restore and transaction id wraparound