Re: checkpoints, proper config

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: checkpoints, proper config
Date: 2015-12-10 22:45:41
Message-ID: 20151210224541.GQ2763@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2015-12-11 01:20:29 Re: checkpoints, proper config
Previous Message Tomas Vondra 2015-12-10 22:40:18 Re: checkpoints, proper config