pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Clamp result of MultiXactMemberFreezeThreshold 6+ messages / 1 participants [nested] [flat]
* pgsql: Clamp result of MultiXactMemberFreezeThreshold @ 2024-06-13 16:04 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2024-06-13 16:04 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Clamp result of MultiXactMemberFreezeThreshold The purpose of the function is to reduce the effective autovacuum_multixact_freeze_max_age if the multixact members SLRU is approaching wraparound, to make multixid freezing more aggressive. The returned value should therefore never be greater than plain autovacuum_multixact_freeze_max_age. Reviewed-by: Robert Haas Discussion: https://www.postgresql.org/message-id/85fb354c-f89f-4d47-b3a2-3cbd461c90a3@iki.fi Backpatch-through: 12, all supported versions Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b91b3f045abeaad4599bdac9ad7d7f55d7ff234c Modified Files -------------- src/backend/access/transam/multixact.c | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Clamp result of MultiXactMemberFreezeThreshold @ 2024-06-13 16:04 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2024-06-13 16:04 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Clamp result of MultiXactMemberFreezeThreshold The purpose of the function is to reduce the effective autovacuum_multixact_freeze_max_age if the multixact members SLRU is approaching wraparound, to make multixid freezing more aggressive. The returned value should therefore never be greater than plain autovacuum_multixact_freeze_max_age. Reviewed-by: Robert Haas Discussion: https://www.postgresql.org/message-id/85fb354c-f89f-4d47-b3a2-3cbd461c90a3@iki.fi Backpatch-through: 12, all supported versions Branch ------ REL_12_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/a5662ba345e732c1f714409b38b75be98105aab6 Modified Files -------------- src/backend/access/transam/multixact.c | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Clamp result of MultiXactMemberFreezeThreshold @ 2024-06-13 16:04 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2024-06-13 16:04 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Clamp result of MultiXactMemberFreezeThreshold The purpose of the function is to reduce the effective autovacuum_multixact_freeze_max_age if the multixact members SLRU is approaching wraparound, to make multixid freezing more aggressive. The returned value should therefore never be greater than plain autovacuum_multixact_freeze_max_age. Reviewed-by: Robert Haas Discussion: https://www.postgresql.org/message-id/85fb354c-f89f-4d47-b3a2-3cbd461c90a3@iki.fi Backpatch-through: 12, all supported versions Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/d881f6fdf5e8346cd8924d4fd671a886a39853d3 Modified Files -------------- src/backend/access/transam/multixact.c | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Clamp result of MultiXactMemberFreezeThreshold @ 2024-06-13 16:04 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2024-06-13 16:04 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Clamp result of MultiXactMemberFreezeThreshold The purpose of the function is to reduce the effective autovacuum_multixact_freeze_max_age if the multixact members SLRU is approaching wraparound, to make multixid freezing more aggressive. The returned value should therefore never be greater than plain autovacuum_multixact_freeze_max_age. Reviewed-by: Robert Haas Discussion: https://www.postgresql.org/message-id/85fb354c-f89f-4d47-b3a2-3cbd461c90a3@iki.fi Backpatch-through: 12, all supported versions Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/566a7d9182de9c06b786a747dfd3d42a938299c7 Modified Files -------------- src/backend/access/transam/multixact.c | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Clamp result of MultiXactMemberFreezeThreshold @ 2024-06-13 16:04 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2024-06-13 16:04 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Clamp result of MultiXactMemberFreezeThreshold The purpose of the function is to reduce the effective autovacuum_multixact_freeze_max_age if the multixact members SLRU is approaching wraparound, to make multixid freezing more aggressive. The returned value should therefore never be greater than plain autovacuum_multixact_freeze_max_age. Reviewed-by: Robert Haas Discussion: https://www.postgresql.org/message-id/85fb354c-f89f-4d47-b3a2-3cbd461c90a3@iki.fi Backpatch-through: 12, all supported versions Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/c425113eebb7dbc7f0031ed97b32f267a9cac75f Modified Files -------------- src/backend/access/transam/multixact.c | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Clamp result of MultiXactMemberFreezeThreshold @ 2024-06-13 16:04 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2024-06-13 16:04 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Clamp result of MultiXactMemberFreezeThreshold The purpose of the function is to reduce the effective autovacuum_multixact_freeze_max_age if the multixact members SLRU is approaching wraparound, to make multixid freezing more aggressive. The returned value should therefore never be greater than plain autovacuum_multixact_freeze_max_age. Reviewed-by: Robert Haas Discussion: https://www.postgresql.org/message-id/85fb354c-f89f-4d47-b3a2-3cbd461c90a3@iki.fi Backpatch-through: 12, all supported versions Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/7768ac1c17f0ec7883825e8768ab480caa7842ec Modified Files -------------- src/backend/access/transam/multixact.c | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2024-06-13 16:04 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-06-13 16:04 pgsql: Clamp result of MultiXactMemberFreezeThreshold Heikki Linnakangas <heikki.linnakangas@iki.fi> 2024-06-13 16:04 pgsql: Clamp result of MultiXactMemberFreezeThreshold Heikki Linnakangas <heikki.linnakangas@iki.fi> 2024-06-13 16:04 pgsql: Clamp result of MultiXactMemberFreezeThreshold Heikki Linnakangas <heikki.linnakangas@iki.fi> 2024-06-13 16:04 pgsql: Clamp result of MultiXactMemberFreezeThreshold Heikki Linnakangas <heikki.linnakangas@iki.fi> 2024-06-13 16:04 pgsql: Clamp result of MultiXactMemberFreezeThreshold Heikki Linnakangas <heikki.linnakangas@iki.fi> 2024-06-13 16:04 pgsql: Clamp result of MultiXactMemberFreezeThreshold Heikki Linnakangas <heikki.linnakangas@iki.fi>
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