Re: OIDs (Or: another RTFM question?) - Mailing list pgsql-general

Joel Rees wrote:
> 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.  While
> > the system itself isn't fazed by such a wraparound, user programs that
> > look at OIDs might be.
>
> How much of a pain would it be to make that a 64-bit counter? Would that
> create conflicts with the SQL standard?
>
> (No, I don't contribute code, so if that's a really stupid idea, just tell
> me so.)

Not hard, but another 4 bytes per row and some small performance
penalty.  Also, not all system support 64-bit ints.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026