Re: Re: 4 billion record limit? - Mailing list pgsql-general

From Tom Lane
Subject Re: Re: 4 billion record limit?
Date
Msg-id 28547.964763208@sss.pgh.pa.us
Whole thread Raw
In response to Re: 4 billion record limit?  (Chris Jones <cjones@rightnowtech.com>)
List pgsql-general
Chris Jones <cjones@rightnowtech.com> writes:
> So, assuming these numbers are reasonable, and assuming that Moore's
> Law applies to PG usage, we could have trouble with 64-bit OIDs in
> maybe 40 years.

Interesting point.  However, once we bite the bullet of not tying
OID == int32, it should be relatively painless to equate OID to any
compiler-supported integer type.  So we should only need to fix
this problem once.  If your projection is accurate, no doubt C2020
will consider "long long long int" to be a required type ;-)

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump error
Next
From: Tom Lane
Date:
Subject: Re: 4 billion record limit?