Re: pg_restore and transaction id wraparound

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Browne <cbbrowne(at)acm(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_restore and transaction id wraparound
Date: 2003-11-29 19:29:09
Message-ID: 8535.1070134149@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Christopher Browne <cbbrowne(at)acm(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ow 2003-11-29 20:11:47 Re: pg_restore and transaction id wraparound
Previous Message Bruce Momjian 2003-11-29 19:28:59 Re: Misplaced modifier in Postgresql license