Re: Proposing pg_hibernate

Поиск
Список
Период
Сортировка
От Gurjeet Singh
Тема Re: Proposing pg_hibernate
Дата
Msg-id CABwTF4VtGN6654OVML9Nb9ktbJ4UD-J27kW2NKwwPF7jRqmjAg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Proposing pg_hibernate  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
On Wed, Jun 4, 2014 at 2:52 PM, Andres Freund <andres@2ndquadrant.com> wrote:
> On 2014-06-04 14:50:39 -0400, Robert Haas wrote:
>> The thing I was concerned about is that the system might have been in
>> recovery for months.  What was hot at the time the base backup was
>> taken seems like a poor guide to what will be hot at the time of
>> promotion. Consider a history table, for example: the pages at the
>> end, which have just been written, are much more likely to be useful
>> than anything earlier.
>
> I'd assumed that the hibernation files would simply be excluded from the
> basebackup...

Yes, they will be excluded, provided the BlockReader processes have
finished, because each BlockReader unlinks its save-file after it is
done restoring buffers listed in it.

Best regards,
-- 
Gurjeet Singh http://gurjeet.singh.im/

EDB www.EnterpriseDB.com



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

Предыдущее
От: Gurjeet Singh
Дата:
Сообщение: Re: Proposing pg_hibernate
Следующее
От: Gurjeet Singh
Дата:
Сообщение: Re: Proposing pg_hibernate