Re: Add WAL read stats to pg_stat_wal - Mailing list pgsql-hackers

From Kyotaro Horiguchi
Subject Re: Add WAL read stats to pg_stat_wal
Date
Msg-id 20230220.142139.1342228878531675049.horikyota.ntt@gmail.com
Whole thread Raw
In response to Re: Add WAL read stats to pg_stat_wal  (Andres Freund <andres@anarazel.de>)
Responses Re: Add WAL read stats to pg_stat_wal
Re: Add WAL read stats to pg_stat_wal
List pgsql-hackers
At Thu, 16 Feb 2023 11:11:38 -0800, Andres Freund <andres@anarazel.de> wrote in 
> I wonder if we should keep the checkpointer around for longer. If we have
> checkpointer signal postmaster after it wrote the shutdown checkpoint,
> postmaster could signal walsenders to shut down, and checkpointer could do
> some final work, like writing out the stats.
> I suspect this could be useful for other things as well. It's awkward that we
> don't have a place to put "just before shutting down" type tasks. And
> checkpointer seems well suited for that.

I totally agree that it will be useful, but I'm not quite sure how
checkpointer would be able to let postmaster know about that state
without requiring access to shared memory.

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: DSA failed to allocate memory
Next
From: Michael Paquier
Date:
Subject: Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes?