Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by hub.org (8.10.1/8.10.1) with ESMTP id e99J4FJ44053 for ; Mon, 9 Oct 2000 15:04:15 -0400 (EDT) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.3) with HTTP id 1097898; Mon, 09 Oct 2000 12:04:14 -0700 From: "Josh Berkus" Subject: Re: OID Perfomance - Object-Relational databases To: Bruce Momjian , Josh Berkus Cc: pgsql-sql@postgresql.org, jeff@pgsql.com X-Mailer: CommuniGate Pro Web Mailer v.3.3 Date: Mon, 09 Oct 2000 12:04:14 -0700 Message-ID: In-Reply-To: <200010091836.OAA01228@candle.pha.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200010/87 Bruce, Tom, etc.: > > This is what I mean. Does the DB engine only recycle > > *unused* OIDs (that is, does it check for teh continued > > existance of a tuple with OID 198401)? If that's the > > method, then there isn't really a problem even if I do > use > > OIDs as a primary index. None of my OIDs still in use > will > > be touched. > > > No, it uses all oids, and can create duplicates. Does this mean that Tom's "Wraparound Ragnarok" is the accurate scenario? -Josh Berkus