Re: postmaster startup time

"Steve Oualline" <soualline(at)stbernard(dot)com> writes:
> What's the longest time you'd expect between the execution of the=20
> postmaster command and being able to connec?

Normal startup is a second or two on any modern hardware. If you have
to recover from WAL, though, it could be very long. A rule of thumb is
that it shouldn't take longer than your inter-checkpoint time
(checkpoint_timeout) ... but that's only assuming that the most recent
checkpoint attempt before the crash succeeded. We've seen cases where
checkpoints were failing repeatedly (eg, because of out-of-space
condition on the main data partition) but the system kept merrily
spooling transactions into WAL. In a scenario like that, there could be
a whole lot of WAL to replay :-(

regards, tom lane