On Sun, Aug 7, 2011 at 8:57 AM, Hannu Krosing <ha...@2ndquadrant.com> wrote: > In 9.0 (as in earlier versions) a former standby host has to do a full > checkpoint before becoming available as an independent database instance > in either switchover or failover scenarios. > > For most combinations of of bigger than minimal shared buffers and > non-memory-speed disks this can take from several seconds to tens of > minutes on busy systems.
For switchover, you issue a checkpoint first, to reduce this time as much as possible. > Is the pre-activation checkpoint still required in 9.1 ? Yes, but I've found a way to remove them in 9.2 and will be patching that soon. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers