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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: john(at)august(dot)com
Cc: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] maximum number of rows in table - what about oid limits?
Date: 2001-06-07 02:05:52
Message-ID: 6630.991879552@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

John Scott <jmscott(at)yahoo(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-06-07 02:13:11 Re: maximum number of rows in table - what about oid limits?
Previous Message Justin Clift 2001-06-07 01:18:54 USE_AUSTRALIAN_RULES breaks regression tests in 7.1.2?

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-06-07 02:13:11 Re: maximum number of rows in table - what about oid limits?
Previous Message Stephan Szabo 2001-06-07 01:12:51 Re: behavior of ' = NULL' vs. MySQL vs. Standards