Re: Is a high tab_reloid worrying?

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(at)wardbrook(dot)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.