]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix stats_fetch_consistency with stats for fixed-numbered objects
authorMichael Paquier <michael@paquier.xyz>
Thu, 1 Feb 2024 08:13:11 +0000 (17:13 +0900)
committerMichael Paquier <michael@paquier.xyz>
Thu, 1 Feb 2024 08:13:11 +0000 (17:13 +0900)
commit171d21f50c3ee3f17911daa3d91eb75363669a11
tree84db63e891a473c7c9ad646d629611a61bb7ea35
parent41fa4b31c12f4affc5d0ed1e257dacaf2bbe0731
Fix stats_fetch_consistency with stats for fixed-numbered objects

This impacts the statistics retrieved in transactions for the following
views when updating the value of stats_fetch_consistency, leading to
behaviors contrary to what is documented since 605994651b6a as an update
of this parameter should discard all statistics snapshot data:
- pg_stat_archiver
- pg_stat_bgwriter
- pg_stat_checkpointer
- pg_stat_io
- pg_stat_slru
- pg_stat_wal

For example, updating stats_fetch_consistency from "snapshot" to "cache"
in a transaction did not re-fetch any fresh data, using data cached from
the time when "snapshot" was in use.

Author: Shinya Kato
Discussion: https://postgr.es/m/d77fc5190d4dbe1738d77231488e768b@oss.nttdata.com
Backpatch-through: 15
src/backend/utils/activity/pgstat.c