RE: New statistics for tuning WAL buffer size
Masahiro Ikeda <ikedamsh@oss.nttdata.com>
From: Masahiro Ikeda <ikedamsh@oss.nttdata.com>
To: tsunakawa.takay@fujitsu.com
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2020-08-19T05:10:08Z
Lists: pgsql-hackers
On 2020-08-19 13:49, tsunakawa.takay@fujitsu.com wrote: > From: Masahiro Ikeda <ikedamsh@oss.nttdata.com> >> If my understanding is correct, we have to measure the performance >> impact first. >> Do you know HariBabu is now trying to solve it? If not, I will try to >> modify patches to apply HEAD. > > No, he's not doing it anymore. It'd be great if you could resume it. OK, thanks. > However, I recommend sharing your understanding about what were the > issues with those two threads and how you're trying to solve them. > Was the performance overhead the blocker in both of the threads? In my understanding, some comments are not solved in both of the threads. I think the following works are remained. 1) Modify patches to apply HEAD 2) Get consensus what metrics we collect and how to use them for tuning. 3) Measure performance impact and if it leads poor performance, we solve it. Regards, -- Masahiro Ikeda NTT DATA CORPORATION
Commits
-
Add pg_stat_wal statistics view.
- 8d9a935965f0 14.0 landed