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 e99NUsJ42259 for ; Mon, 9 Oct 2000 19:30:54 -0400 (EDT) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id TAA26524; Mon, 9 Oct 2000 19:30:47 -0400 (EDT) From: Bruce Momjian Message-Id: <200010092330.TAA26524@candle.pha.pa.us> Subject: Re: OID Perfomance - Object-Relational databases In-Reply-To: <39E24A53.1E07F0EE@agliodbs.com> "from Josh Berkus at Oct 9, 2000 03:44:35 pm" To: josh@agliodbs.com Date: Mon, 9 Oct 2000 19:30:47 -0400 (EDT) CC: Tom Lane , 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/94 X-Sequence-Number: 1756 There is an FAQ item about oid's already on the web site. It may not be in 7.0.2. > Tom, Bruce, > > Thanks. I think that gives me a pretty clear picture. How can we > submit this whole OID thing to the PGSQL FAQ? Want me to write it up? > > -Josh Berkus > > P.S. BTW, my conclusion based on this discussion is that I will not use > the OIDs for indexing/linking. Instead, I will embrace Michael's > earlier suggestion and have already created universal_sq and started > migrating primary keys to that sequence. > > P.P.S. Thank you both for taking the time to hash out this issue. > > > -- > ______AGLIO DATABASE SOLUTIONS___________________________ > Josh Berkus > Complete information technology josh@agliodbs.com > and data management solutions (415) 436-9166 > for law firms, small businesses fax 436-0137 > and non-profit organizations. pager 338-4078 > San Francisco > -- 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