Re: OID Perfomance - Object-Relational databases

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org, jeff(at)pgsql(dot)com
Subject: Re: OID Perfomance - Object-Relational databases
Date: 2000-10-09 19:04:14
Message-ID: web-1097898@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2000-10-09 19:19:03 Re: OID Perfomance - Object-Relational databases
Previous Message Josh Berkus 2000-10-09 17:34:38 Re: OID Perfomance - Object-Relational databases