Re: log_checkpoint's "WAL file(s) added" is misleading to the point of uselessness

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: log_checkpoint's "WAL file(s) added" is misleading to the point of uselessness
Дата
Msg-id 20210727005059.ugv6dkzaqyvv3bvy@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: log_checkpoint's "WAL file(s) added" is misleading to the point of uselessness  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Список pgsql-hackers
Hi,

On 2021-07-25 12:10:07 +0900, Fujii Masao wrote:
> It's also worth showing them in monitoring stats view like pg_stat_wal?

I'm not convinced that's all that meaningful. It makes sense to include
it as part of the checkpoint output, because checkpoints determine when
WAL can be recycled etc. It's not that clear to me how to represent that
as part of pg_stat_wal?

I guess we could add columns for the amount of WAL has been a) newly
created b) recycled c) removed. In combination that *does* seem
useful. But also a mostly independent change...

Greetings,

Andres Freund



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: log_checkpoint's "WAL file(s) added" is misleading to the point of uselessness
Следующее
От: "houzj.fnst@fujitsu.com"
Дата:
Сообщение: RE: row filtering for logical replication