Is a high tab_reloid worrying?

Поиск
Список
Период
Сортировка
От John Sidney-Woollett
Тема Is a high tab_reloid worrying?
Дата
Msg-id 443E14A5.5030408@wardbrook.com
обсуждение исходный текст
Ответы Re: [Slony1-general] Is a high tab_reloid worrying?  (Hannu Krosing <hannu@skype.net>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: unattened dump
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: [Slony1-general] Is a high tab_reloid worrying?