Re: OID Perfomance - Object-Relational databases - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: OID Perfomance - Object-Relational databases
Date
Msg-id 200010092330.TAA26524@candle.pha.pa.us
Whole thread Raw
In response to Re: OID Perfomance - Object-Relational databases  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
There is an FAQ item about oid's already on the web site.  It may not
be in 7.0.2.

> Tom, Bruce,
> 
>     Thanks.  I think that gives me a pretty clear picture.  How can we
> submit this whole OID thing to the PGSQL FAQ?  Want me to write it up?
> 
>                     -Josh Berkus
> 
> P.S. BTW, my conclusion based on this discussion is that I will not use
> the OIDs for indexing/linking.  Instead, I will embrace Michael's
> earlier suggestion and have already created universal_sq and started
> migrating primary keys to that sequence.  
> 
> P.P.S. Thank you both for taking the time to hash out this issue.
> 
> 
> -- 
> ______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
> 


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: [HACKERS] foreign key introduces unnecessary locking ?
Next
From: "Nema, Vivek"
Date:
Subject: -query sql