NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit171d21f

committed

Fix stats_fetch_consistency with stats for fixed-numbered objects

This impacts the statistics retrieved in transactions for the followingviews when updating the value of stats_fetch_consistency, leading tobehaviors contrary to what is documented since6059946 as an updateof 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_walFor example, updating stats_fetch_consistency from "snapshot" to "cache"in a transaction did not re-fetch any fresh data, using data cached fromthe time when "snapshot" was in use.Author: Shinya KatoDiscussion:https://postgr.es/m/d77fc5190d4dbe1738d77231488e768b@oss.nttdata.comBackpatch-through: 15

1 parent41fa4b3 commit171d21fCopy full SHA for 171d21f

File tree

1 file changed

-0

lines changed

src/backend/utils/activity
- pgstat.c

1 file changed

-0

lines changed

`‎src/backend/utils/activity/pgstat.c`

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -918,6 +918,9 @@ pgstat_snapshot_fixed(PgStat_Kind kind)`
`918`	`918`	`AssertArg(pgstat_is_kind_valid(kind));`
`919`	`919`	`AssertArg(pgstat_get_kind_info(kind)->fixed_amount);`
`920`	`920`
	`921`	`+if (force_stats_snapshot_clear)`
	`922`	`+pgstat_clear_snapshot();`
	`923`	`+`
`921`	`924`	`if (pgstat_fetch_consistency==PGSTAT_FETCH_CONSISTENCY_SNAPSHOT)`
`922`	`925`	`pgstat_build_snapshot();`
`923`	`926`	`else`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit171d21f

File tree

1 file changed

1 file changed

`‎src/backend/utils/activity/pgstat.c`

0 commit comments