Re: Is a high tab_reloid worrying?

Поиск
Список
Период
Сортировка
От John Sidney-Woollett
Тема Re: Is a high tab_reloid worrying?
Дата
Msg-id 443E59DF.5080301@wardbrook.com
обсуждение исходный текст
Ответ на Re: Is a high tab_reloid worrying?  (Christopher Browne <cbbrowne@acm.org>)
Список pgsql-general
Thanks for the reassurance. You're right the db has been around for a while.

Doea anyone know if OIDs for data and system (DDL) objects from the same
number generator?

John

Christopher Browne wrote:
> In an attempt to throw the authorities off his trail, johnsw@wardbrook.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.

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

Предыдущее
От: "Sadm sadm"
Дата:
Сообщение: ...
Следующее
От: "chris smith"
Дата:
Сообщение: Re: posting request