On Wed, 2021-10-20 at 23:29 +0300, Radoslav Nedyalkov wrote:
> 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.
Hard to say, perhaps you are creating lots of temporary tables (watch out
for pg_attribute bloat!). The OID counter will simply wrap around, but there
will be no duplicate OIDs in pg_class.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com