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
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? |
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 |