Re: [SQL] maximum number of rows in table - what about oid limits?

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