Re: pg_migrator progress

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: pg_migrator progress
Дата
Msg-id 878wo321r5.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: pg_migrator progress  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pg_migrator progress
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> No, but this would just be the same situation that prevails after
> OID-counter wraparound, so I don't see a compelling need for us to
> change the OID counter in the new DB.  If the user has done the Proper
> Things (ie, made unique indexes on his OIDs) then it won't matter.
> If he didn't, his old DB was a time bomb anyway.

Well it was a time bomb but it wasn't necessarily about to go off... He may
very well know how close or far he is from oid wraparound and have contingency
plans in place. 

Also I wonder about the performance of skipping over thousands or even
millions of OIDs for something like a toast table.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication
support!


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

Предыдущее
От: David Fetter
Дата:
Сообщение: SIMILAR TO bug?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: SIMILAR TO bug?