RE: OID Perfomance - Object-Relational databases

<p><font size="2">Hi, Josh,</font><p><font size="2">In fact, the last point about OIDs is particularly pertinent,
becausewe are expected to process up to 500 million records daily, thus exhausting the limit in, um, eight
days.</font><p><fontsize="2">Is anybody aware of when this limit will be raised.</font><p><font
size="2">Cheers...</font><p><fontsize="2">>>   -----Original Message-----</font><br /><font size="2">>>  
From:Josh Berkus [<a href="mailto:josh@agliodbs.com">mailto:josh@agliodbs.com</a>]</font><br /><font
size="2">>>  Sent: 03 October 2000 17:06</font><br /><font size="2">>>   To: sqllist</font><br /><font
size="2">>>  Cc: Jeff MacDonald</font><br /><font size="2">>>   Subject: [SQL] OID Perfomance -
Object-Relationaldatabases</font><br /><font size="2">>>   </font><br /><font size="2">>>   </font><br
/><fontsize="2">>>   Folks,</font><br /><font size="2">>>   </font><br /><font size="2">>>     
Becauseit's a very elegant solution to my database </font><br /><font size="2">>>   structure issues,</font><br
/><fontsize="2">>>   I'm using OID's extensively as referents and foriegn keys. </font><br /><font
size="2">>>   However, I</font><br /><font size="2">>>   wanted to see if others had previous experience in
this</font><br /><font size="2">>>   (answer as many</font><br /><font size="2">>>   as you
like):</font><br/><font size="2">>>   </font><br /><font size="2">>>   1. Is there a performance loss on
searchesand joins when </font><br /><font size="2">>>   I use the OID</font><br /><font size="2">>>   as a
linikingfield as opposed to a SERIAL column?</font><br /><font size="2">>>   </font><br /><font
size="2">>>  2. Can I define my own index on the OIDs of a table?</font><br /><font size="2">>>  
</font><br/><font size="2">>>   3. What is the difference between these two DDL statements </font><br /><font
size="2">>>  in terms of</font><br /><font size="2">>>   data access and PG-SQL performance (assuming that
tableclients has</font><br /><font size="2">>>   already been defined):</font><br /><font size="2">>>  
</font><br/><font size="2">>>   CREATE TABLE client_addresses AS (</font><br /><font size="2">>>     
client_OID     OID     REFERENCES clients,</font><br /><font size="2">>>      address1        VARCHAR
(30),</font><br/><font size="2">>>      address2        VARCHAR (30),</font><br /><font size="2">>>     
address3       VARCHAR (30)</font><br /><font size="2">>>      )</font><br /><font size="2">>>  
and:</font><br/><font size="2">>>   CREATE TABLE client_addresses AS (</font><br /><font size="2">>>     
client         clients,</font><br /><font size="2">>>      address1        VARCHAR (30),</font><br /><font
size="2">>>     address2        VARCHAR (30),</font><br /><font size="2">>>      address3        VARCHAR
(30)</font><br/><font size="2">>>      )</font><br /><font size="2">>>   </font><br /><font
size="2">>>  (This is Michael's questions rephrased)</font><br /><font size="2">>>   </font><br /><font
size="2">>>  4. Int4 seems kinda small to me for a value that needs to enumerate</font><br /><font
size="2">>>  every single database object.  Within a couple of years of </font><br /><font size="2">>>  
heavyuse, a</font><br /><font size="2">>>   customer-transaction database could easily exceed 2 billion
objects</font><br/><font size="2">>>   created (and destroyed).  Are there plans to expand this to
Int8?</font><br/><font size="2">>>   </font><br /><font size="2">>>   -Josh Berkus</font><br /><font
size="2">>>  </font><br /><font size="2">>>   P.S. My aplolgies if I've already posted these questions; I
never</font><br/><font size="2">>>   received them back from the list mailer.</font><br /><font
size="2">>>     </font><br /><font size="2">>>   </font><br /><font size="2">>>   </font><br /><font
size="2">>>  -- </font><br /><font size="2">>>   ______AGLIO DATABASE
SOLUTIONS___________________________</font><br/><font size="2">>>                                           Josh
Berkus</font><br/><font size="2">>>      Complete information technology      josh@agliodbs.com</font><br /><font
size="2">>>      and data management solutions       (415) 436-9166</font><br /><font size="2">>>      for
lawfirms, small businesses       fax  436-0137</font><br /><font size="2">>>       and non-profit
organizations.      pager 338-4078</font><br /><font size="2">>>                                      San
Francisco</font><br/><font size="2">>>   </font>