Re: OID Perfomance - another question - Mailing list pgsql-sql

From Mitch Vincent
Subject Re: OID Perfomance - another question
Date
Msg-id 00b701c02d56$3a301180$0200000a@doot
Whole thread Raw
In response to OID Perfomance - Object-Relational databases  (Josh Berkus <josh@agliodbs.com>)
Responses Re: OID Perfomance - another question
List pgsql-sql
Aren't there a pretty big concerns when using OIDs as IDs to relate records
in different tables to each other? Wouldn't the OIDs be totally re-assigned
if you had to dump/restore your database?

Just a question to satisfy my own curiosity, thanks!

-Mitch

> Folks,
>
> Because it's a very elegant solution to my database structure issues,
> I'm using OID's extensively as referents and foriegn keys.  However, I
> wanted to see if others had previous experience in this (answer as many
> as you like):
>
> 1. Is there a performance loss on searches and joins when I use the OID
> as a liniking field as opposed to a SERIAL column?




pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Something I'd like to try...
Next
From: Tod McQuillin
Date:
Subject: Re: OID Perfomance - another question