| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Checkpoint throttling issues |
| Date: | 2015-10-19 19:35:52 |
| Message-ID: | 20151019193552.GN3391@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2015-10-19 20:34:13 | Re: Foreign join pushdown vs EvalPlanQual |
| Previous Message | Fabien COELHO | 2015-10-19 19:27:20 | Re: Checkpoint throttling issues |