32bit OID wrap around concerns

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема 32bit OID wrap around concerns
Дата
Msg-id CAJjS0u3mHZ-DekdkR5ETULQ3ZNNGTo_md=Q-DapR_+=b_Z+YCg@mail.gmail.com
обсуждение исходный текст
Ответы Re: 32bit OID wrap around concerns  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
One scenario is to use an oid to identify a toast value. As the oid generation is mono increased within a database instance, it can gets wrap around after 2^32 generations. After that:
1. GetNewOidWithIndex() could gets unbounded performance as it needs to by pass already in use values of its own.  
2. These by-passed oids are actually usable by other toast indices, but are wasted. This can lead to further aggravated OID wrap around. 
 
Do we think above scenario is something we shall worry about? Especially for large databases. 
 
Thanks,
Qingqing
 

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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Bug in pg_dump
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: 32bit OID wrap around concerns