Re: OIDs (Or: another RTFM question?)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joel Rees <joel(at)alpsgiken(dot)gr(dot)jp>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: OIDs (Or: another RTFM question?)
Date: 2002-07-17 03:22:57
Message-ID: 10639.1026876177@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joel Rees <joel(at)alpsgiken(dot)gr(dot)jp> writes:
> Tom Lane explained:
>> Basically what WITHOUT OIDS does for you is to reduce consumption of
>> OIDs, thereby postponing wraparound of the 32-bit OID counter.

> How much of a pain would it be to make that a 64-bit counter?

It'd be nontrivial, primarily because of portability issues: not all
platforms even have 64-bit ints, much less 64-bit ints that are fast
enough to justify making a core datatype be 64 bits. (Not only OID,
but also Datum, would have to become 64 bits. That is a *very*
pervasive change, and one with serious implications for performance.)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-07-17 03:30:58 Re: Fortran functions?
Previous Message Bruce Momjian 2002-07-17 03:18:17 Re: OIDs (Or: another RTFM question?)