"Steve Oualline" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
