Re: Why has postmaster shutdown gotten so slow?

Jan Wieck wrote:

> Tom Lane wrote:
> 
>> Shutdown of an idle postmaster used to take about two or three seconds
>> (mostly due to the sync/sleep(2)/sync in md_sync).  For the last couple
>> of days it's taking more like a dozen seconds.  I presume somebody broke
>> something, but I'm unsure whether to pin the blame on bgwriter or
>> Windows changes.  Anyone care to fess up?
> 
> I guess it could well be the bgwriter, which when having nothing to do 
> at all is sleeping for 10 seconds. Not sure, will check.

I checked the background writer for this and I can not reproduce the 
behaviour. If the bgwriter had zero blocks to write it does PG_USLEEP 
for 10 seconds, which on Unix is done by select() and that is correctly 
interrupted when the postmaster sends it the term signal on shutdown.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #