Re: Cluster OID Limit

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Lucas <lucas75(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Cluster OID Limit
Date: 2022-06-09 15:02:40
Message-ID: 3d888421-7ed3-eab7-7102-5a83b293074b@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6/9/22 02:10, Lucas wrote:
> Hello,
>
> In the company I work for, some clusters reached the OID limit (2^32)
> and we had to reinstall the cluster.

Was this really about OIDs or XID wraparound?:

https://www.postgresql.org/docs/14/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND

>
> I was wondering if there is any discussion on:
> * "compress" the OID space
> * "warp around" the OID space
> * segment a OID range for temporary tables with "wrap around"
>
> --
> Lucas

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message SERHAD ERDEM 2022-06-09 15:08:26 Re: Cluster OID Limit
Previous Message Tom Lane 2022-06-09 13:49:21 Re: Cluster OID Limit