On Sun, Aug 7, 2011 at 8:57 AM, Hannu Krosing <hannu@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