RE: New statistics for tuning WAL buffer size

Поиск
Список
Период
Сортировка
От tsunakawa.takay@fujitsu.com
Тема RE: New statistics for tuning WAL buffer size
Дата
Msg-id TYAPR01MB29901792EA2A9FFE9307444FFE5C0@TYAPR01MB2990.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на New statistics for tuning WAL buffer size  (Masahiro Ikeda <ikedamsh@oss.nttdata.com>)
Ответы RE: New statistics for tuning WAL buffer size  (Masahiro Ikeda <ikedamsh@oss.nttdata.com>)
Список pgsql-hackers
From: Masahiro Ikeda <ikedamsh@oss.nttdata.com>
> 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.

Yes, it's helpful to know if we need to enlarge the WAL buffer.  That's why our colleague HariBabu proposed the patch.
We'dbe happy if it could be committed in some form. 


> 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/CAJrrPGc6APFUGYNcPe4qcNx
> pL8gXKYv1KST%2BvwJcFtCSCEySnA%40mail.gmail.com

What's the difference between those patches?  What blocked them from being committed?


Regards
Takayuki Tsunakawa




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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Display individual query in pg_stat_activity
Следующее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: Is it worth accepting multiple CRLs?