From: Tom Lane <tgl@sss.pgh.pa.us>
To: Richard Huxton <dev@archonet.com>
Cc: daniel alvarez <d-alvarez@gmx.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: OIDs as keys
Date: Wed, 26 Feb 2003 11:02:30 -0500
Message-ID: <29927.1046275350@sss.pgh.pa.us> (raw)
In-Reply-To: <200302261358.53730.dev@archonet.com>
References: <1859.1046264679@www36.gmx.net>
<200302261358.53730.dev@archonet.com>
Richard Huxton <dev@archonet.com> writes:
>> How unique are oids as of version 7.3 of postgres ?
> OIDs are unique per object (table) I believe, no more so.
Even then, you should only assume uniqueness if you put a unique index
on the table's OID column to enforce it. (The system catalogs that use
OID all have such indexes.) Without that, you might have duplicates
after the OID counter wraps around.
>> Will the oid type be extended so that oids can be larger than 4 bytes (if
>> this is still correct for 7.3) and do not rotate in large systems?
> Strikes me as unlikely, though I'm not a developer.
I tend to agree. At one point that was a live possibility, but now
we're more likely to change the default for user tables to WITHOUT OIDS
and declare the problem solved. Making OIDs 8 bytes looks like too much
of a performance hit for non-64-bit machines. (Not to mention machines
that haven't got "long long" at all; right now the only thing that
doesn't work for them is type int8, and I'd like it to stay that way,
at least for a few more years.)
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, dev@archonet.com, d-alvarez@gmx.de
Subject: Re: OIDs as keys
In-Reply-To: <29927.1046275350@sss.pgh.pa.us>
References: <1859.1046264679@www36.gmx.net> <200302261358.53730.dev@archonet.com> <29927.1046275350@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox