Re: Is a high tab_reloid worrying? - Mailing list pgsql-general

From John Sidney-Woollett
Subject Re: Is a high tab_reloid worrying?
Date
Msg-id 443E59DF.5080301@wardbrook.com
Whole thread Raw
In response to Re: Is a high tab_reloid worrying?  (Christopher Browne <cbbrowne@acm.org>)
List pgsql-general
Thanks for the reassurance. You're right the db has been around for a while.

Doea anyone know if OIDs for data and system (DDL) objects from the same
number generator?

John

Christopher Browne wrote:
> In an attempt to throw the authorities off his trail, johnsw@wardbrook.com (John Sidney-Woollett) transmitted:
>
>>I just added a new table to a slony relication set. The new table
>>seems to have a really high tab_reloid value of 94,198,669
>
>
> I presume the database instance has been around for a while?  If so,
> then I wouldn't worry too much.
>
> I'm not certain comprehensively what would consume OIDs, but I expect
> temp tables would, so if you have applications that generate them,
> that would naturally lead to increases in OID values.
>
> The only time you get *low* values is if you define tables immediately
> after creating the database.

pgsql-general by date:

Previous
From: "Sadm sadm"
Date:
Subject: ...
Next
From: "chris smith"
Date:
Subject: Re: posting request