Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by hub.org (8.10.1/8.10.1) with ESMTP id e92FdhP54662 for ; Mon, 2 Oct 2000 11:39:43 -0400 (EDT) Received: from [206.169.43.135] (HELO agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.3) with ESMTP id 1095660 for pgsql-sql@postgresql.org; Mon, 02 Oct 2000 08:39:21 -0700 Message-ID: <39D8AC3E.A8E2C8BF@agliodbs.com> Date: Mon, 02 Oct 2000 08:39:42 -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: sqllist Subject: Concerns about the OID Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/5 Folks, I'm made rather extensive use of PGSQL's universal OID in my database design. However, now that I'm building the interface for my first transaction datbase in PGSQL, I'm concerned about a couple of things: 1. Has anyone experienced any performance problems relating tables/classes via OID? 2. Can I add an index on OIDs for a particular table? 3. Int4 seems sort of small for a number that has to uniquely identify every object in the database. Are there plans to expand the OID to Int8? -Josh -- ______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