| 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: | Whole Thread | Raw Message | 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.
| 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 |