Re: Ever increasing OIDs - gonna run out soon?

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Re: Ever increasing OIDs - gonna run out soon?
Дата
Msg-id e6ihu6$1fqo$1@news.hub.org
обсуждение исходный текст
Ответ на Ever increasing OIDs - gonna run out soon?  (John Sidney-Woollett <johnsw@wardbrook.com>)
Ответы Re: Ever increasing OIDs - gonna run out soon?  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-general
"John Sidney-Woollett" <johnsw@wardbrook.com> wrote
>
> It looks like the db is using them at the rate of 1.5 million per day.
> At what value will I hit a wraparound, and what options do I have to
> identify/fix the (impending) problem.
>

The Oid will wraparound when it reaches the 32bits unsigned integer limit.
If you don't use the oid explicitely in your application, then you don't
worry about it.

Regards,
Qingqing



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

Предыдущее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: Disk corruption detection
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Pgpool-committers unsubscribe notification