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

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: john(at)august(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 21:58:09
Message-ID: Pine.BSF.4.21.0106061454140.17516-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

> my question is, since oid's are used by the
> postgres kernel, what effect does oid wrapping have upon
> the stability of the database. for example, does oid wrapping mean
> i might clash with oid's in the system tables.

Let me try again. I've been having problems trying to write it out
I fear.

AFAIK, the only real clashes you have to worry about are oid clashes
between rows within the same system table that have unique constraints
on oid. That means that your table rows shouldn't conflict, and you
shouldn't even get conflicts between different system tables. So,
you could get a conflict when say creating a table between an old
pg_class row and the one that was going to be created and the
create table would fail and need to be tried again, but if you
had a pg_class row oid 10000, and 100 other rows with oid 10000
in your own tables there's no conflict.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex Pilosov 2001-06-06 21:58:52 Re: [HACKERS] something smells bad
Previous Message John Scott 2001-06-06 21:52:34 Re: [SQL] maximum number of rows in table - what about oid limits?

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-06-06 22:37:00 Re: [SQL] maximum number of rows in table - what about oid limits?
Previous Message John Scott 2001-06-06 21:52:34 Re: [SQL] maximum number of rows in table - what about oid limits?