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
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) |