"Gurjeet Singh" <[EMAIL PROTECTED]> writes: > On 12/18/06, Tom Lane <[EMAIL PROTECTED]> wrote: >> There is already an option to sleep early in backend startup for the >> normal case. Not sure if it works for bootstrap, autovacuum, etc, >> but I could see making it do so.
> You are probably referring to the command-line switch -W to posrgres, that > translates to 'PostAuthDelay' GUC variable; I think that kicks in a bit too > late! No, I was thinking of PreAuthDelay. There might be cases where even that is too late in the procedure --- probably not on Unix, but on Windows there's a lot that happens before BackendInitialize. But offhand I don't know how we'd have a configurable delay much earlier ... custom insertions of hardwired delays into the source code are probably the only good approach if you find that, say, guc.c initialization fails in individual backends under Windows. Back at the ranch, though, the question was whether it'd be worth honoring PreAuthDelay in the other startup code paths such as BootstrapMain. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly