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

From Stephan Szabo
Subject Re: [SQL] maximum number of rows in table - what about oid limits?
Date
Msg-id Pine.BSF.4.21.0106061454140.17516-100000@megazone23.bigpanda.com
Whole thread Raw
List pgsql-general
> 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.


pgsql-general by date:

Previous
From: Martín Marqués
Date:
Subject: Re: [HACKERS] something smells bad
Next
From: Bruno Wolff III
Date:
Subject: using create constraint trigger