Re: Cluster OID Limit

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lucas <lucas75(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Cluster OID Limit
Date: 2022-06-09 13:49:21
Message-ID: 1989057.1654782561@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lucas <lucas75(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2022-06-09 15:02:40 Re: Cluster OID Limit
Previous Message Shaozhong SHI 2022-06-09 13:37:54 A function to find errors in groups in a table