Re: pg_class.oid at 4B

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Radoslav Nedyalkov <rnedyalkov(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_class.oid at 4B
Date: 2021-10-20 21:20:43
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Radoslav Nedyalkov <rnedyalkov(at)gmail(dot)com> 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 temporary tables, maybe?

> Also what happens when pg_class.oid reaches 4B.

Nothing. The counter will wrap around and you won't notice a thing.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-10-20 21:46:01 Re: Can we get rid of repeated queries from pg_dump?
Previous Message David G. Johnston 2021-10-20 20:39:10 Re: pg_class.oid at 4B