On Thu, Jan 26, 2017 at 8:45 PM, Peter Eisentraut <peter.eisentr...@2ndquadrant.com> wrote: > On 1/24/17 3:26 AM, Mithun Cy wrote: >> In my code by default, we only dump at shutdown time. If we want to >> dump at regular interval then we need to set the GUC >> pg_autoprewarm.buff_dump_interval to > 0. > > Just a thought with an additional use case: If I want to set up a > standby for offloading queries, could I take the dump file from the > primary or another existing standby, copy it to the new standby, and > have it be warmed up to the state of the other instance from that? > > In my experience, that kind of use is just as interesting as preserving > the buffers across a restart. >
An interesting use case. I am not sure if somebody has tried that way but it appears to me that the current proposed patch should work for this use case. -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
