Re: Cluster OID Limit - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Cluster OID Limit
Date
Msg-id 3d888421-7ed3-eab7-7102-5a83b293074b@aklaver.com
Whole thread Raw
In response to Cluster OID Limit  (Lucas <lucas75@gmail.com>)
Responses Re: Cluster OID Limit  (SERHAD ERDEM <serhade@hotmail.com>)
List 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.klaver@aklaver.com



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cluster OID Limit
Next
From: SERHAD ERDEM
Date:
Subject: Re: Cluster OID Limit