Thread: pgsql: Trigger more frequent autovacuums with relallfrozen
Trigger more frequent autovacuums with relallfrozen Calculate the insert threshold for triggering an autovacuum of a relation based on the number of unfrozen pages. By only considering the unfrozen portion of the table when calculating how many tuples to add to the insert threshold, we can trigger more frequent vacuums of insert-heavy tables. This increases the chances of vacuuming those pages when they still reside in shared buffers This also increases the number of autovacuums triggered by tuples inserted and not by wraparound risk. We prefer to freeze these pages during insert-triggered autovacuums, as anti-wraparound vacuums are not automatically canceled by conflicting lock requests. We calculate the unfrozen percentage of the table using the recently added (99f8f3fbbc8f) relallfrozen column of pg_class. Author: Melanie Plageman <melanieplageman@gmail.com> Reviewed-by: Nathan Bossart <nathandbossart@gmail.com> Reviewed-by: Greg Sabino Mullane <htamfids@gmail.com> Reviewed-by: Robert Treat <rob@xzilla.net> Reviewed-by: wenhui qiu <qiuwenhuifx@gmail.com> Discussion: https://postgr.es/m/flat/CAAKRu_aj-P7YyBz_cPNwztz6ohP%2BvWis%3Diz3YcomkB3NpYA--w%40mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/06eae9e6218ab2acf64ea497bad0360e4c90e32d Modified Files -------------- doc/src/sgml/catalogs.sgml | 7 ++++--- doc/src/sgml/config.sgml | 15 +++++++-------- src/backend/postmaster/autovacuum.c | 27 ++++++++++++++++++++++++--- src/backend/utils/misc/postgresql.conf.sample | 4 ++-- 4 files changed, 37 insertions(+), 16 deletions(-)