Re: pg_class.oid at 4B

2021-10-20 Thread Laurenz Albe
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

Re: pg_class.oid at 4B

2021-10-20 Thread Tom Lane
Radoslav Nedyalkov writes: > 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. Lots of short-lived tempo

Re: pg_class.oid at 4B

2021-10-20 Thread David G. Johnston
On Wednesday, October 20, 2021, Radoslav Nedyalkov wrote: > 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

pg_class.oid at 4B

2021-10-20 Thread Radoslav Nedyalkov
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_cl