Re: Question about debugging bootstrapping and catalog entries - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Question about debugging bootstrapping and catalog entries
Date
Msg-id 14308.1166681529@sss.pgh.pa.us
Whole thread Raw
In response to Re: Question about debugging bootstrapping and catalog entries  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
List pgsql-hackers
"Gurjeet Singh" <singh.gurjeet@gmail.com> writes:
> On 12/18/06, Tom Lane <tgl@sss.pgh.pa.us> 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Stats Collector Oddity
Next
From: Tom Lane
Date:
Subject: Re: ERROR: tuple concurrently updated