Re: checkpoints, proper config - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: checkpoints, proper config
Date
Msg-id 20151210224541.GQ2763@alvherre.pgsql
Whole thread Raw
In response to Re: checkpoints, proper config  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: checkpoints, proper config  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-performance
Tomas Vondra wrote:

> Also, I don't think it makes much sense to set
>
>    (checkpoint_warning > checkpoint_timeout)
>
> as it kinda defeats the whole purpose of the warning.

I agree, but actually, what is the sense of checkpoint_warning?  I think
it was useful back when we didn't have log_checkpoints, but now that we
have detailed checkpoint logging I think it's pretty much useless noise.

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


pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: checkpoints, proper config
Next
From: Tomas Vondra
Date:
Subject: Re: checkpoints, proper config