Search Postgresql Archives

Is a high tab_reloid worrying?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux