Received: from candle.pha.pa.us (pgman@nav-43.dsl.navpoint.com [162.33.245.46]) by hub.org (8.10.1/8.10.1) with ESMTP id e99JJ7J61058 for ; Mon, 9 Oct 2000 15:19:08 -0400 (EDT) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id PAA11482; Mon, 9 Oct 2000 15:19:03 -0400 (EDT) From: Bruce Momjian Message-Id: <200010091919.PAA11482@candle.pha.pa.us> Subject: Re: OID Perfomance - Object-Relational databases In-Reply-To: "from Josh Berkus at Oct 9, 2000 12:04:14 pm" To: Josh Berkus Date: Mon, 9 Oct 2000 15:19:03 -0400 (EDT) CC: pgsql-sql@postgresql.org, jeff@pgsql.com X-Mailer: ELM [version 2.4ME+ PL77 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200010/88 [ Charset ISO-8859-1 unsupported, converting... ] > 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? Yes. -- 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