Re: pg_restore and transaction id wraparound

From: ow <oneway_111(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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 20:11:47
Message-ID: 20031129201147.94126.qmail@web21410.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Christopher Browne 2003-11-30 00:32:04 Re: pg_restore and transaction id wraparound
Previous Message Tom Lane 2003-11-29 19:29:09 Re: pg_restore and transaction id wraparound