Re: should we enable log_checkpoints out of the box?

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: should we enable log_checkpoints out of the box?
Date: 2021-11-02 11:00:15
Message-ID: C69EBE8E-A4F0-4B42-A2E7-0DE74CA2EF58@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 1 Nov 2021, at 14:02, Magnus Hagander <magnus(at)hagander(dot)net> wrote:

> There is still some data that log_checkpoint gives you that the statistics don't -- but maybe we should instead look at exposing that information in pg_stat_bgwriter, rather than changing the default.

I don't have strong opinions on changing the default, but +1 on at
investigating exposing the information in the view for monitoring.

--
Daniel Gustafsson https://vmware.com/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dilip Kumar 2021-11-02 11:10:39 Re: Error "initial slot snapshot too large" in create replication slot
Previous Message Daniel Gustafsson 2021-11-02 10:57:18 Re: Extension ownership and misuse of SET ROLE/SET SESSION AUTHORIZATION