New statistics for tuning WAL buffer size

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



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

Предыдущее
От: Masahiro Ikeda
Дата:
Сообщение: Re: Display individual query in pg_stat_activity
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Display individual query in pg_stat_activity