Re: Re: 4 billion record limit?

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Chris Jones <cjones@rightnowtech.com>
Cc: pgsql-general@postgresql.org
Date: 2000-07-28T05:46:48Z
Lists: pgsql-general, pgsql-novice
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