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
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 |