Re: Is a high tab_reloid worrying?

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Is a high tab_reloid worrying?
Date: 2006-04-13 12:32:28
Message-ID: 874q0xk65f.fsf@wolfe.cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.
--
output = ("cbbrowne" "@" "gmail.com")
http://linuxdatabases.info/info/slony.html
As of next Tuesday, all terminal input will be line-at-a-time.
Please update your programs.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sadm sadm 2006-04-13 12:46:24
Previous Message Balazs.Klein 2006-04-13 12:02:28 Re: case insensitive match in unicode