Re: New statistics for tuning WAL buffer size - Mailing list pgsql-hackers

From Kyotaro Horiguchi
Subject Re: New statistics for tuning WAL buffer size
Date
Msg-id 20200928.115416.175989928927733297.horikyota.ntt@gmail.com
Whole thread Raw
In response to Re: New statistics for tuning WAL buffer size  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: New statistics for tuning WAL buffer size  (Amit Kapila <amit.kapila16@gmail.com>)
List 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



pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: Load TIME fields - proposed performance improvement
Next
From: Greg Nancarrow
Date:
Subject: Re: Parallel INSERT (INTO ... SELECT ...)