Concerns about the OID

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: sqllist <pgsql-sql(at)postgresql(dot)org>
Subject: Concerns about the OID
Date: 2000-10-02 15:39:42
Message-ID: 39D8AC3E.A8E2C8BF@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)agliodbs(dot)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

Browse pgsql-sql by date

  From Date Subject
Next Message Rini Dutta 2000-10-02 15:39:51 foreign key introduces unnecessary locking ?
Previous Message Fabrice Scemama 2000-10-02 10:19:38 Re: Q: spinlock on Alpha? (PG7.0.2)