pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: John Scott <jmscott@yahoo.com>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: pgsql-general@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] maximum number of rows in table - what about oid limits?
Date: Wed, 6 Jun 2001 11:45:08 -0700 (PDT)
Message-ID: <20010606184508.46169.qmail@web10004.mail.yahoo.com> (raw)
In-Reply-To: <Pine.BSF.4.21.0106061050520.16377-100000@megazone23.bigpanda.com>

well i wasn't interested in using oids in my application.
i was curious about the relationship oids
and the tuple/row limit.

i guess if what you say is true, the oids are NOT used internally
by postgres.  this seems odd.

so, i guess my question still stands ... what happens when oids wrap?
are oids nothing more than a sequence with an index,
not used at all internally?

i
--- Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote:
> 
> On 6 Jun 2001, jmscott@REMOVEMEyahoo.com wrote:
> 
> > postgresql docs claim an essentially unlimited number of
> > rows per table.
> > 
> >    http://postgresql.crimelabs.net/users-lounge/limitations.html
> > 
> > this doesn't make sense if each row has an oid.
> > do more subtle side effects exist if the oid wraps?
> 
> In general, unless you're relying on unique oids, you should be fine.
> You probably don't want to use oid as a unique key in your tables for that
> reason. Of course, sequences aren't sufficient either (also being
> int4) but some kind of int8 "sequence" mechanism would do it if you expect
> more than the int4 number of rows.
> 
> You might have problems with creating system table entries with unique
> oids after wraparound, but generally that can be fixed by trying again.
> (Some of the system tables have a unique index on oid).
> 


=====
John Scott (john@august.com)
Senior Partner
August Associates

email: john@august.com
  web: http://www.august.com/~jmscott

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/



view thread (25+ messages)  latest in thread

Message-ID: <20010606184508.46169.qmail@web10004.mail.yahoo.com>
Permalink:  ../20010606184508.46169.qmail@web10004.mail.yahoo.com/
Also on:    postgresql.org/message-id/20010606184508.46169.qmail@web10004.mail.yahoo.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 using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jmscott@yahoo.com, sszabo@megazone23.bigpanda.com, pgsql-general@postgresql.org
  Subject: Re: [SQL] maximum number of rows in table - what about oid limits?
  In-Reply-To: <20010606184508.46169.qmail@web10004.mail.yahoo.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