Postgres Pro
Downloads
Home   >   mailing lists

Re: Cluster OID Limit - Mailing list pgsql-general

From Joshua Drake
Subject Re: Cluster OID Limit
Date
Msg-id CAJvJg-TNNdPUfqKCMBFcMGwTo9BDjcENtAbci2dB6xc72Lbp2g@mail.gmail.com
Whole thread Raw
In response to Cluster OID Limit  (Lucas <lucas75@gmail.com>)
List pgsql-general
Tree view
Lucas,

If you run out of OIDs you are doing something wrong. We haven't supported user space OIDs in a lot of releases. Which release are you using?

JD

On Thu, Jun 9, 2022 at 2:11 AM Lucas <lucas75@gmail.com> wrote:
Hello,

In the company I work for, some clusters reached the OID limit (2^32) and we had to reinstall the cluster. 

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

pgsql-general by date:

Previous
From: SERHAD ERDEM
Date:
Subject: Re: Cluster OID Limit
Next
From: Joshua Drake
Date:
Subject: Re: Sharing DSA pointer between parallel workers after they've been created