Re: Why has postmaster shutdown gotten so slow?

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: Why has postmaster shutdown gotten so slow?
Дата
Msg-id 402292D8.8050903@Yahoo.com
обсуждение исходный текст
Ответ на Re: Why has postmaster shutdown gotten so slow?  (Jan Wieck <JanWieck@Yahoo.com>)
Ответы Re: Why has postmaster shutdown gotten so slow?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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 #



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Austin Gonyou
Дата:
Сообщение: Re: PITR Dead horse?
Следующее
От: evgen
Дата:
Сообщение: Re: Recursive queries?