Re: [SQL] maximum number of rows in table - what about oid limits?

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/