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

From Josh Berkus
Subject Re: OID Perfomance - Object-Relational databases
Date
Msg-id web-1097898@davinci.ethosmedia.com
Whole thread Raw
In response to OID Perfomance - Object-Relational databases  (Josh Berkus <josh@agliodbs.com>)
Responses Re: OID Perfomance - Object-Relational databases
Re: OID Perfomance - Object-Relational databases
List pgsql-sql
Bruce, Tom, etc.:

> > This is what I mean.  Does the DB engine only recycle
> > *unused* OIDs (that is, does it check for teh continued
> > existance of a tuple with OID 198401)?  If that's the
> > method, then there isn't really a problem even if I do
> use
> > OIDs as a primary index.  None of my OIDs still in use
> will
> > be touched.
> 
> 
> No, it uses all oids, and can create duplicates.

Does this mean that Tom's "Wraparound Ragnarok" is the
accurate scenario?

-Josh Berkus


pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: OID Perfomance - Object-Relational databases
Next
From: Bruce Momjian
Date:
Subject: Re: OID Perfomance - Object-Relational databases