Re: Proposing pg_hibernate - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Proposing pg_hibernate
Date
Msg-id 20140604185244.GA785@awork2.anarazel.de
Whole thread Raw
In response to Re: Proposing pg_hibernate  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Proposing pg_hibernate  (Gurjeet Singh <gurjeet@singh.im>)
List pgsql-hackers
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...

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Sigh, we need an initdb
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Sigh, we need an initdb