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. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
