On Aug 7, 2011, at 11:01 AM, Simon Riggs wrote:
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
this is highly interesting. this is am important issue for big iron.
can you share the idea you have in mind?
Cybertec Schönig Schönig GmbH
A-2700 Wiener Neustadt, Austria
Sent via pgsql-hackers mailing list (email@example.com)
To make changes to your subscription: