From: John Naylor <john.naylor@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Lower minimum maintenance_work_mem to 64kB
Date: Sat, 10 Aug 2024 08:19:12 +0000
Message-ID: <E1schJg-003Xp5-K7@gemulon.postgresql.org> (raw)
Lower minimum maintenance_work_mem to 64kB
Since the introduction of TID store, vacuum uses far less memory in
the common case than in versions 16 and earlier. Invoking multiple
rounds of index vacuuming in turn requires a much larger table. It'd
be a good idea anyway to cover this case in regression testing, and a
lower limit is less painful for slow buildfarm animals. The reason to
do it now is to re-enable coverage of the bugfix in commit 83c39a1f7f.
For consistency, give autovacuum_work_mem the same treatment.
Suggested by Andres Freund
Tested by Melanie Plageman
Backpatch to v17, where TID store was introduced
Discussion: https://postgr.es/m/20240516205458.ohvlzis5b5tvejru@awork3.anarazel.de
Discussion: https://postgr.es/m/20240722164745.fvaoh6g6zprisqgp%40awork3.anarazel.de
Branch
------
REL_17_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/2eda3df9ad532a051976937cfc17d6c52bbdacd6
Modified Files
--------------
src/backend/postmaster/autovacuum.c | 6 +++---
src/backend/utils/misc/guc_tables.c | 7 ++++++-
src/backend/utils/misc/postgresql.conf.sample | 4 ++--
3 files changed, 11 insertions(+), 6 deletions(-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: john.naylor@postgresql.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Lower minimum maintenance_work_mem to 64kB
In-Reply-To: <E1schJg-003Xp5-K7@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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