Re: Cluster OID Limit - Mailing list pgsql-general

From Tom Lane
Subject Re: Cluster OID Limit
Date
Msg-id 1989057.1654782561@sss.pgh.pa.us
Whole thread Raw
In response to Cluster OID Limit  (Lucas <lucas75@gmail.com>)
List pgsql-general
Lucas <lucas75@gmail.com> writes:
> In the company I work for, some clusters reached the OID limit (2^32) and
> we had to reinstall the cluster.

Uh ... why did you think you needed to do that?  The OID counter
will wrap around and things should carry on fine.  There are defenses
to prevent creation of duplicate OID values within any one catalog
or TOAST table, and it doesn't particularly matter if there are
duplicates across tables.

            regards, tom lane



pgsql-general by date:

Previous
From: Shaozhong SHI
Date:
Subject: A function to find errors in groups in a table
Next
From: Adrian Klaver
Date:
Subject: Re: Cluster OID Limit