Re: PATCH: Exclude unlogged tables from base backups

Поиск
Список
Период
Сортировка
От David Steele
Тема Re: PATCH: Exclude unlogged tables from base backups
Дата
Msg-id a6eaa71b-0859-f848-72c2-31d2d4744fe5@pgmasters.net
обсуждение исходный текст
Ответ на Re: PATCH: Exclude unlogged tables from base backups  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On 12/12/17 6:33 PM, Andres Freund wrote:
> 
> On 2017-12-12 18:30:47 -0500, David Steele wrote:
>>> If we had a way to prevent relfilenode reuse across multiple checkpoints
>>> this'd be easier, although ALTER TABLE SET UNLOGGED still'd complicate.
>>
>> Or error the backup if there is wraparound?
> 
> That seems entirely unacceptable to me. On a machine with lots of
> toasting etc going on an oid wraparound doesn't take a long time. We've
> only one oid counter for all tables, and relfilenodes are inferred from
> that ....

Fair enough.  I'll think on it.

-- 
-David
david@pgmasters.net


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: PATCH: Exclude unlogged tables from base backups
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Leftover reference to replacement selection 1 run case