Re: Fwd: [BUG]: the walsender does not update its IO statistics until it exits
Michael Paquier <michael@paquier.xyz>
From: Michael Paquier <michael@paquier.xyz>
To: Xuneng Zhou <xunengzhou@gmail.com>
Cc: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Andres Freund <andres@anarazel.de>
Date: 2025-03-19T05:26:47Z
Lists: pgsql-hackers
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
Commits
-
Flush the IO statistics of active WAL senders more frequently
- e2a82cd23a88 16.9 landed
- 5cbbe70a9cc6 17.5 landed
- 039549d70f6a 18.0 landed
-
Optimize check for pending backend IO stats
- 6d3ea48ff1ae 18.0 landed