Re: Checkpoint throttling issues

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Checkpoint throttling issues
Дата
Msg-id 20151019193552.GN3391@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: Checkpoint throttling issues  (Fabien COELHO <coelho@cri.ensmp.fr>)
Ответы Re: Checkpoint throttling issues  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
Fabien COELHO wrote:

> >4) It's a bit dubious to only pgstat_send_bgwriter() when on schedule.
> 
> No opinion!

My guess here, without looking, is that this was based on the idea of
"oops, we're late here for the checkpoint, let's do as less work as
possible to avoid getting even later", and thus skip some "unnecessary"
tasks.  I would vote for fixing this (and the SIGHUP issue too).  I'm
not sure how bad a behavioral change this is; IMO these fixes should be
backpatched all the way back.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: Checkpoint throttling issues
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Foreign join pushdown vs EvalPlanQual