pgsql: Add log_autoanalyze_min_duration

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add log_autoanalyze_min_duration
Date: 2025-10-15 12:36:33
Message-ID: E1v90k5-001ogd-0e@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(dot)kato(at)gmail(dot)com>
Reviewed-by: Kasahara Tatsuhito <kasaharatt(at)oss(dot)nttdata(dot)com>
Discussion: https://www.postgresql.org/message-id/flat/CAOzEurQtfV4MxJiWT-XDnimEeZAY+rgzVSLe8YsyEKhZcajzSA(at)mail(dot)gmail(dot)com

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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2025-10-15 13:27:12 pgsql: Change reset_extra into a config_generic common field
Previous Message Etsuro Fujita 2025-10-15 08:18:07 pgsql: Fix EvalPlanQual handling of foreign/custom joins in ExecScanFet