Monitoring time of fsyncing WALs

Поиск
Список
Период
Сортировка
От Konstantin Knizhnik
Тема Monitoring time of fsyncing WALs
Дата
Msg-id 4a243897-0ad8-f471-aa40-242591f2476e@postgrespro.ru
обсуждение исходный текст
Ответы Re: Monitoring time of fsyncing WALs  (David Steele <david@pgmasters.net>)
Re: Monitoring time of fsyncing WALs  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
I wonder why we are monitoring time of writing to WAL, but not time of 
fsyncing WAL segments?
Is there are principle reason for it or just because nobody added it yet?
If so, please find very small patch which adding WAIT_EVENT_WAL_FSYNC 
event type.

Our engineers in PgPro complain me that there is no information about 
time spent in syncing WALs...
Unfortunately Postgres still is not able to aggregate this statistic. 
But at least we have pg_wait_sampling extension for it:
https://github.com/postgrespro/pg_wait_sampling

-- 
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


Вложения

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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: "wal receiver" process hang in syslog() while exiting afterreceiving SIGTERM while the postgres has been promoted.
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Supporting tls-server-end-point as SCRAM channel binding forOpenSSL 1.0.0 and 1.0.1