Concerns about the OID
| От | Josh Berkus |
|---|---|
| Тема | Concerns about the OID |
| Дата | |
| Msg-id | 39D8AC3E.A8E2C8BF@agliodbs.com обсуждение исходный текст |
| Список | 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 informationtechnology 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
В списке pgsql-sql по дате отправления: