Re: Fwd: [BUG]: the walsender does not update its IO statistics until it exits

Поиск
Список
Период
Сортировка
Искать
От
Michael Paquier
Тема
Re: Fwd: [BUG]: the walsender does not update its IO statistics until it exits
Дата
Msg-id
Z9pVl5bF0xH8HY_9@paquier.xyz
Ответ на
Список
Дерево обсуждения
[BUG]: the walsender does not update its IO statistics until it exits Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: [BUG]: the walsender does not update its IO statistics until it exits Michael Paquier <michael@paquier.xyz>
Re: [BUG]: the walsender does not update its IO statistics until it exits Andres Freund <andres@anarazel.de>
Re: [BUG]: the walsender does not update its IO statistics until it exits Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: [BUG]: the walsender does not update its IO statistics until it exits Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: [BUG]: the walsender does not update its IO statistics until it exits Michael Paquier <michael@paquier.xyz>
Re: [BUG]: the walsender does not update its IO statistics until it exits Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: [BUG]: the walsender does not update its IO statistics until it exits Michael Paquier <michael@paquier.xyz>
Re: [BUG]: the walsender does not update its IO statistics until it exits Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: [BUG]: the walsender does not update its IO statistics until it exits Michael Paquier <michael@paquier.xyz>
Re: [BUG]: the walsender does not update its IO statistics until it exits Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: [BUG]: the walsender does not update its IO statistics until it exits Andres Freund <andres@anarazel.de>
Re: [BUG]: the walsender does not update its IO statistics until it exits Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: [BUG]: the walsender does not update its IO statistics until it exits Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: [BUG]: the walsender does not update its IO statistics until it exits Michael Paquier <michael@paquier.xyz>
Re: [BUG]: the walsender does not update its IO statistics until it exits Michael Paquier <michael@paquier.xyz>
Re: [BUG]: the walsender does not update its IO statistics until it exits Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: [BUG]: the walsender does not update its IO statistics until it exits Michael Paquier <michael@paquier.xyz>
Re: [BUG]: the walsender does not update its IO statistics until it exits Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: [BUG]: the walsender does not update its IO statistics until it exits Michael Paquier <michael@paquier.xyz>
Re: [BUG]: the walsender does not update its IO statistics until it exits Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: [BUG]: the walsender does not update its IO statistics until it exits Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: [BUG]: the walsender does not update its IO statistics until it exits Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
On Wed, Mar 19, 2025 at 09:53:16AM +0800, Xuneng Zhou wrote:
> I think these two conditions are good too. In a busy system, they are met
> frequently, so the flush routine will be executed at least once every
> second. Conversely, when WAL generation is low, there's simply less data to
> record, and the flush frequency naturally decreases.

Hmm, yeah, perhaps this is acceptable.  The changes in pgstat.c seem
inconsistent, though, only moving the min interval while the max and
idle times stay around.

This also make me wonder if we should work towards extending
pgstat_report_stat(), so as we save in GetCurrentTimestamp() while
making the internals still local to pgstat.c.  Or perhaps not in the
scope of a backpatchable design.
--
Michael
В списке pgsql-hackers по дате отправления
От: Jeremy Schneider
Дата:
От: Bertrand Drouvot
Дата:
FAQ