On Thu, Jan 19, 2017 at 6:20 AM, Stephen Frost <sfr...@snowman.net> wrote: > On Wed, Jan 18, 2017 at 16:15 Robert Haas <robertmh...@gmail.com> wrote: >> On Wed, Jan 18, 2017 at 3:59 PM, Stephen Frost <sfr...@snowman.net> wrote: >> > For non-cold standby configurations, pg_ctl is going to return just as >> > soon as the database has finished crash recovery, which in most cases >> > will probably be on the order of a few seconds. >> >> /me is poleaxed. >> >> Yeah, that was a confused sentence- most of the time it's going to return >> on the order of a few seconds because we're doing regular startup without >> having to do any crash recovery. >> >> >> For actual crash recovery cases, it'll take between a few seconds and >> checkpoint_timeout, as I described up-thread, based on the amount of >> outstanding WAL.
Recovering up to the minumum recovery point could take minutes! -- Michael -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers