From: Peter Eisentraut <peter@eisentraut.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Add log_autoanalyze_min_duration
Date: Wed, 15 Oct 2025 12:36:33 +0000
Message-ID: <E1v90k5-001ogd-0e@gemulon.postgresql.org> (raw)
Add log_autoanalyze_min_duration
The log output functionality of log_autovacuum_min_duration applies to
both VACUUM and ANALYZE, so it is not possible to separate the VACUUM
and ANALYZE log output thresholds. Logs are likely to be output only for
VACUUM and not for ANALYZE.
Therefore, we decided to separate the threshold for log output of VACUUM
by autovacuum (log_autovacuum_min_duration) and the threshold for log
output of ANALYZE by autovacuum (log_autoanalyze_min_duration).
Author: Shinya Kato <shinya11.kato@gmail.com>
Reviewed-by: Kasahara Tatsuhito <kasaharatt@oss.nttdata.com>
Discussion: https://www.postgresql.org/message-id/flat/CAOzEurQtfV4MxJiWT-XDnimEeZAY+rgzVSLe8YsyEKhZcajzSA@mail....
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/dd3ae378301f7e84c18f7a90f183c3cd4165c0da
Modified Files
--------------
doc/src/sgml/config.sgml | 41 ++++++++++++++++++++++-----
doc/src/sgml/maintenance.sgml | 3 +-
doc/src/sgml/ref/create_table.sgml | 15 ++++++++++
src/backend/access/common/reloptions.c | 15 ++++++++--
src/backend/access/heap/vacuumlazy.c | 6 ++--
src/backend/commands/analyze.c | 8 +++---
src/backend/commands/vacuum.c | 10 +++++--
src/backend/postmaster/autovacuum.c | 16 ++++++++---
src/backend/utils/misc/guc_parameters.dat | 14 +++++++--
src/backend/utils/misc/postgresql.conf.sample | 7 ++++-
src/bin/psql/tab-complete.in.c | 1 +
src/include/commands/vacuum.h | 11 +++++--
src/include/postmaster/autovacuum.h | 1 +
src/include/utils/rel.h | 3 +-
src/test/regress/pg_regress.c | 1 +
src/tools/ci/pg_ci_base.conf | 1 +
16 files changed, 122 insertions(+), 31 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: peter@eisentraut.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Add log_autoanalyze_min_duration
In-Reply-To: <E1v90k5-001ogd-0e@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