NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitc425113

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 parentf839087 commitc425113Copy full SHA for c425113

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
`@@ -2932,6 +2932,7 @@ MultiXactMemberFreezeThreshold(void)`
`2932`	`2932`	`uint32multixacts;`
`2933`	`2933`	`uint32victim_multixacts;`
`2934`	`2934`	`doublefraction;`
	`2935`	`+intresult;`
`2935`	`2936`
`2936`	`2937`	`/* If we can't determine member space utilization, assume the worst. */`
`2937`	`2938`	`if (!ReadMultiXactCounts(&multixacts,&members))`
`@@ -2953,7 +2954,13 @@ MultiXactMemberFreezeThreshold(void)`
`2953`	`2954`	`/* fraction could be > 1.0, but lowest possible freeze age is zero */`
`2954`	`2955`	`if (victim_multixacts>multixacts)`
`2955`	`2956`	`return0;`
`2956`		`-returnmultixacts-victim_multixacts;`
	`2957`	`+result=multixacts-victim_multixacts;`
	`2958`	`+`
	`2959`	`+/*`
	`2960`	`+ * Clamp to autovacuum_multixact_freeze_max_age, so that we never make`
	`2961`	`+ * autovacuum less aggressive than it would otherwise be.`
	`2962`	`+ */`
	`2963`	`+returnMin(result,autovacuum_multixact_freeze_max_age);`
`2957`	`2964`	`}`
`2958`	`2965`
`2959`	`2966`	`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!

Commitc425113

File tree

1 file changed

1 file changed

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

0 commit comments