On Thursday, May 24, 2012 08:46:21 PM Tom Lane wrote: > Andres Freund <and...@anarazel.de> writes: > > On Thursday, May 24, 2012 08:32:47 PM Tom Lane wrote: > >> I'm not sure I believe that we can make a recovery resume from an > >> arbitrary point in WAL anyway, or that it would be worth the trouble. > >> Can't we just resume from the last restartpoint? > > > > Well, with a decent sized checkpoint_segments getting up2date can take > > quite a noticeable amount of time... > > So? Slow restart is precisely the price you pay for a large checkpoint > interval. Well. no. If you stop the master in a orderly fashion it will checkpoint and thus have a sensible startup time. There is no such possibility for a standby without interaction with the master.
Andres -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, 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
