Re: maximum number of rows in table - what about oid limits? - Mailing list pgsql-sql

From Tom Lane
Subject Re: maximum number of rows in table - what about oid limits?
Date
Msg-id 6630.991879552@sss.pgh.pa.us
Whole thread Raw
In response to Re: maximum number of rows in table - what about oid limits?  (John Scott <jmscott@yahoo.com>)
List pgsql-sql
John Scott <jmscott@yahoo.com> writes:
> but does retrying fix the problem?  wouldn't the second try just often
> see the same oid again.  does a failed attempt increment the oid????

Yes.

> by the way, have you written anything up on the txid wrapping problem?
> we talked about this at osdn last year in san jose.  i proposed
> 64 bits, and you discussed a clever wrapping algorithm involving 48 bits and,
> if memory serves me, backward compatiablility of the disk format.

The wraparound idea was discussed on pghackers; people didn't like it
much, but I haven't heard a better near-term solution ...

            regards, tom lane

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: behavior of ' = NULL' vs. MySQL vs. Standards
Next
From: Tom Lane
Date:
Subject: Re: maximum number of rows in table - what about oid limits?