From: | John Scott <jmscott(at)yahoo(dot)com> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [SQL] maximum number of rows in table - what about oid limits? |
Date: | 2001-06-06 18:45:08 |
Message-ID: | 20010606184508.46169.qmail@web10004.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
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(at)megazone23(dot)bigpanda(dot)com> wrote:
>
> On 6 Jun 2001, jmscott(at)REMOVEMEyahoo(dot)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(at)august(dot)com)
Senior Partner
August Associates
email: john(at)august(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Somazx Interesting | 2001-06-06 18:49:41 | Slow DROPing Table |
Previous Message | Dave Cramer | 2001-06-06 18:31:09 | Re: bug?: java won't read timestamps |
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Pilosov | 2001-06-06 18:50:14 | Re: How to create a *pass-through-query* in postgresql |
Previous Message | Stephan Szabo | 2001-06-06 17:55:43 | Re: [SQL] maximum number of rows in table - what about oid limits? |