Re: Cluster OID Limit

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Cluster OID Limit
Дата
Msg-id 1989057.1654782561@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Cluster OID Limit  (Lucas <lucas75@gmail.com>)
Список pgsql-general
Lucas <lucas75@gmail.com> writes:
> In the company I work for, some clusters reached the OID limit (2^32) and
> we had to reinstall the cluster.

Uh ... why did you think you needed to do that?  The OID counter
will wrap around and things should carry on fine.  There are defenses
to prevent creation of duplicate OID values within any one catalog
or TOAST table, and it doesn't particularly matter if there are
duplicates across tables.

            regards, tom lane



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

Предыдущее
От: Shaozhong SHI
Дата:
Сообщение: A function to find errors in groups in a table
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Cluster OID Limit