Horton

Re: New statistics for tuning WAL buffer size

Kyotaro Horiguchi <horikyota.ntt@gmail.com>

View thread View on postgr.es
From: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
To: amit.kapila16@gmail.com
Cc: ikedamsh@oss.nttdata.com, masao.fujii@oss.nttdata.com, pgsql-hackers@postgresql.org, tsunakawa.takay@fujitsu.com, magnus@hagander.net
Date: 2020-09-28T02:54:16Z
Lists: pgsql-hackers 
At Mon, 28 Sep 2020 08:11:23 +0530, Amit Kapila <amit.kapila16@gmail.com> wrote in 
> One other thing that occurred to me today is can't we keep this as
> part of PgStat_GlobalStats? We can use pg_stat_reset_shared('wal'); to
> reset it. It seems to me this is a cluster-wide stats and somewhat
> similar to some of the other stats we maintain there.

I like that direction, but PgStat_GlobalStats is actually
PgStat_BgWriterStats and cleard by a RESET_BGWRITER message.

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center

Commits

  1. Add pg_stat_wal statistics view.