Re: Add WAL read stats to pg_stat_wal

Поиск
Список
Период
Сортировка
От Kyotaro Horiguchi
Тема Re: Add WAL read stats to pg_stat_wal
Дата
Msg-id 20230220.142139.1342228878531675049.horikyota.ntt@gmail.com
обсуждение исходный текст
Ответ на Re: Add WAL read stats to pg_stat_wal  (Andres Freund <andres@anarazel.de>)
Ответы Re: Add WAL read stats to pg_stat_wal  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Re: Add WAL read stats to pg_stat_wal  (Andres Freund <andres@anarazel.de>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: DSA failed to allocate memory
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes?