NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitb91b3f0

committed

Clamp result of MultiXactMemberFreezeThreshold

The purpose of the function is to reduce the effectiveautovacuum_multixact_freeze_max_age if the multixact members SLRU isapproaching wraparound, to make multixid freezing more aggressive.The returned value should therefore never be greater than plainautovacuum_multixact_freeze_max_age.Reviewed-by: Robert HaasDiscussion:https://www.postgresql.org/message-id/85fb354c-f89f-4d47-b3a2-3cbd461c90a3@iki.fiBackpatch-through: 12, all supported versions

1 parent5762530 commitb91b3f0Copy full SHA for b91b3f0

File tree

1 file changed

-1

lines changed

src/backend/access/transam
- multixact.c

1 file changed

-1

lines changed

`‎src/backend/access/transam/multixact.c`

Lines changed: 8 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2828,6 +2828,7 @@ MultiXactMemberFreezeThreshold(void)`
`2828`	`2828`	`uint32multixacts;`
`2829`	`2829`	`uint32victim_multixacts;`
`2830`	`2830`	`doublefraction;`
	`2831`	`+intresult;`
`2831`	`2832`
`2832`	`2833`	`/* If we can't determine member space utilization, assume the worst. */`
`2833`	`2834`	`if (!ReadMultiXactCounts(&multixacts,&members))`
`@@ -2849,7 +2850,13 @@ MultiXactMemberFreezeThreshold(void)`
`2849`	`2850`	`/* fraction could be > 1.0, but lowest possible freeze age is zero */`
`2850`	`2851`	`if (victim_multixacts>multixacts)`
`2851`	`2852`	`return0;`
`2852`		`-returnmultixacts-victim_multixacts;`
	`2853`	`+result=multixacts-victim_multixacts;`
	`2854`	`+`
	`2855`	`+/*`
	`2856`	`+ * Clamp to autovacuum_multixact_freeze_max_age, so that we never make`
	`2857`	`+ * autovacuum less aggressive than it would otherwise be.`
	`2858`	`+ */`
	`2859`	`+returnMin(result,autovacuum_multixact_freeze_max_age);`
`2853`	`2860`	`}`
`2854`	`2861`
`2855`	`2862`	`typedefstructmxtruncinfo`

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!

Commitb91b3f0

File tree

1 file changed

1 file changed

`‎src/backend/access/transam/multixact.c`

0 commit comments