Re: OID Perfomance - Object-Relational databases

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: OID Perfomance - Object-Relational databases
Дата
Msg-id 200010092330.TAA26524@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: OID Perfomance - Object-Relational databases  (Josh Berkus <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: [HACKERS] foreign key introduces unnecessary locking ?
Следующее
От: "Nema, Vivek"
Дата:
Сообщение: -query sql