Is a high tab_reloid worrying?

From: John Sidney-Woollett <johnsw(at)wardbrook(dot)com>
To: Slony-I Mailing List <slony1-general(at)gborg(dot)postgresql(dot)org>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Is a high tab_reloid worrying?
Date: 2006-04-13 09:06:45
Message-ID: 443E14A5.5030408@wardbrook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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'm using Slon 1.1.5 with pg 7.4.6 and 7.4.11 on unix

On the master I see (wcprogallery is the new table added to set 4)

tab_id|tab_reloid|tab_relname |tab_nspname|tab_set|tab_idxname
-------+----------+------------+-----------+-------+-------------------
4005| 18284|wccustomer |customer | 4|wccustomer_pkey
...
4035| 18858|wcrecommend |customer | 4|wcrecommend_pkey
4036| 94198669|wcprogallery|customer | 4|wcprogallery_pkey

On the slave I see

tab_id|tab_reloid|tab_relname |tab_nspname|tab_set|tab_idxname
-------+----------+------------+-----------+-------+-------------------
4005| 1671239|wccustomer |customer | 4|wccustomer_pkey
...
4035| 1671608|wcrecommend |customer | 4|wcrecommend_pkey
4036| 5741203|wcprogallery|customer | 4|wcprogallery_pkey

Is this something I should be worried about? Can I find out where all
the intermediate OIDs have gone?

I have around 70 tables and about 200 pgplsql functions in the database.

John

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hannu Krosing 2006-04-13 09:13:02 Re: [Slony1-general] Is a high tab_reloid worrying?
Previous Message Martijn van Oosterhout 2006-04-13 08:47:12 Re: unattened dump