pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: pg_walsummary: Improve stability of test checking statistics 2+ messages / 1 participants [nested] [flat]
* pgsql: pg_walsummary: Improve stability of test checking statistics @ 2025-07-08 04:49 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 2+ messages in thread From: Michael Paquier @ 2025-07-08 04:49 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org pg_walsummary: Improve stability of test checking statistics Per buildfarm member culicidae, the query checking for stats reported by the WAL summarizer related to WAL reads is proving to be unstable. Instead of a one-time query, this commit replaces the logic with a polling query checking for the WAL read stats, making the test more reliable on machines that could be slow with the stats reports. This test has been introduced in f4694e0f35b2, so backpatch down to v18. Reported-by: Alexander Lakhin <exclusion@gmail.com> Reviewed-by: Alexander Lakhin <exclusion@gmail.com> Discussion: https://postgr.es/m/f35ba3db-fca7-4693-bc35-6db64488e4b1@gmail.com Backpatch-through: 18 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/a27893df45ec5d8c657899202e9cf0b9a816fe2f Modified Files -------------- src/bin/pg_walsummary/t/002_blocks.pl | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: pg_walsummary: Improve stability of test checking statistics @ 2025-07-08 04:49 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 2+ messages in thread From: Michael Paquier @ 2025-07-08 04:49 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org pg_walsummary: Improve stability of test checking statistics Per buildfarm member culicidae, the query checking for stats reported by the WAL summarizer related to WAL reads is proving to be unstable. Instead of a one-time query, this commit replaces the logic with a polling query checking for the WAL read stats, making the test more reliable on machines that could be slow with the stats reports. This test has been introduced in f4694e0f35b2, so backpatch down to v18. Reported-by: Alexander Lakhin <exclusion@gmail.com> Reviewed-by: Alexander Lakhin <exclusion@gmail.com> Discussion: https://postgr.es/m/f35ba3db-fca7-4693-bc35-6db64488e4b1@gmail.com Backpatch-through: 18 Branch ------ REL_18_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/330db576f8c37479d472c3e9b0eb6d47ba1d97f4 Modified Files -------------- src/bin/pg_walsummary/t/002_blocks.pl | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-07-08 04:49 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-07-08 04:49 pgsql: pg_walsummary: Improve stability of test checking statistics Michael Paquier <michael@paquier.xyz> 2025-07-08 04:49 pgsql: pg_walsummary: Improve stability of test checking statistics Michael Paquier <michael@paquier.xyz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox