Postgres Pro
Downloads
Home   >   mailing lists

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

From ow
Subject Re: pg_restore and transaction id wraparound
Date
Msg-id 20031129201147.94126.qmail@web21410.mail.yahoo.com
Whole thread Raw
In response to Re: pg_restore and transaction id wraparound  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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.
>

Perhaps noone yet had a table with 4B records in pgSql. Otherwise, how would
they dump/restore it?

Thanks





__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_restore and transaction id wraparound
Next
From: William Yu
Date:
Subject: Re: filesystem suggestion for pg