pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: pgsql-sql@postgresql.org
Subject: Re: OID Perfomance - Object-Relational databases
Date: Mon, 09 Oct 2000 10:34:38 -0700
Message-ID: <web-1097828@davinci.ethosmedia.com> (raw)
In-Reply-To: <web-1097829@davinci.ethosmedia.com>

ruce,

    > The oid counter is preserved with -o on reload. It is
    > not reset.

    I'll let you and Tom duke this one out. :-) It's all
beyond
    me. 

    > > 2. When OID's "wrap around" does the whole database
go
    > > kablooie? If so, why hasn't it happened to anyone
yet?
    > If
    > > not, can you describe the system PGSQL uses to
allocate
    > OIDs
    > > once it gets to 2,147,xxx,xxx?
    > 
    > oid's start getting re-used on wraparound.
    > 

    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.

    If OIDs start getting re-used regardless if they are
already
    present, then, like Tom says, it's Ragnarok. But it
seems
    like somebody would have increased the OID to INT8 if
that
    were a prospect.

    -Josh Berkus

    P.S. Bruce, I'm sorry about not sending my comments on
your
    book. Do you have any use for copy-editing comments from
    the June 28th version, or are you already in pre-press?



view thread (21+ messages)  latest in thread

Message-ID: <web-1097828@davinci.ethosmedia.com>
Permalink:  ../web-1097828@davinci.ethosmedia.com/
Also on:    postgresql.org/message-id/web-1097828@davinci.ethosmedia.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: josh@agliodbs.com
  Subject: Re: OID Perfomance - Object-Relational databases
  In-Reply-To: <web-1097828@davinci.ethosmedia.com>
  References: <web-1097829@davinci.ethosmedia.com> <web-1097828@davinci.ethosmedia.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox