| From: | Masahiro Ikeda <ikedamsh(at)oss(dot)nttdata(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | New statistics for tuning WAL buffer size |
| Date: | 2020-08-18 07:21:26 |
| Message-ID: | 188bd3f2d2233cf97753b5ced02bb050@oss.nttdata.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
It's important to provide the metrics for tuning the size of WAL
buffers.
For now, it's lack of the statistics how often processes wait to write
WAL because WAL buffer is full.
If those situation are often occurred, WAL buffer is too small for the
workload.
DBAs must to tune the WAL buffer size for performance improvement.
There are related threads, but those are not merged.
https://www.postgresql.org/message-id/4FF824F3.5090407@uptime.jp
https://www.postgresql.org/message-id/flat/CAJrrPGc6APFUGYNcPe4qcNxpL8gXKYv1KST%2BvwJcFtCSCEySnA%40mail.gmail.com
What do you think?
If we can have a consensus, I will make a PoC patch.
Regards,
--
Masahiro Ikeda
NTT DATA CORPORATION
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2020-08-18 07:35:05 | Re: Display individual query in pg_stat_activity |
| Previous Message | Masahiro Ikeda | 2020-08-18 06:54:02 | Re: Display individual query in pg_stat_activity |