pg_class.oid at 4B

From: Radoslav Nedyalkov <rnedyalkov(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: pg_class.oid at 4B
Date: 2021-10-20 20:29:20
Message-ID: CANhtRiaHo4Ac90GnZiG7iRMJZPCSGLqSRZTANHRrNReSoP5yig@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,
We have a busy database that has oid increasing with 50-100M per month.
There is no oid type across user attributes anywhere nor user tables with
oids;
Not sure where this generation comes from. If you can hint me, it would be
great.
Also what happens when pg_class.oid reaches 4B.
pg_class itself is ~40K.

Thank you very much,
Rado

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2021-10-20 20:39:10 Re: pg_class.oid at 4B
Previous Message Joel Perren 2021-10-20 16:08:01 Re: Selectivity and row count estimates for JSONB columns