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@xxxxxxxxxxxxx (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.
