Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by hub.org (8.10.1/8.10.1) with ESMTP id e99Mi8J04970 for ; Mon, 9 Oct 2000 18:44:08 -0400 (EDT) Received: from [63.195.55.98] (HELO agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.3) with ESMTP id 1098019; Mon, 09 Oct 2000 15:44:07 -0700 Message-ID: <39E24A53.1E07F0EE@agliodbs.com> Date: Mon, 09 Oct 2000 15:44:35 -0700 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions X-Mailer: Mozilla 4.73 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane CC: Bruce Momjian , pgsql-sql@postgresql.org, jeff@pgsql.com Subject: Re: OID Perfomance - Object-Relational databases References: <6742.971122495@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/91 X-Sequence-Number: 1753 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