public inbox for [email protected]
help / color / mirror / Atom feedFrom: John Naylor <[email protected]>
To: [email protected]
Subject: pgsql: vacuumdb: Add option for analyzing only relations missing stats.
Date: Fri, 07 Mar 2025 03:29:28 +0000
Message-ID: <[email protected]> (raw)
vacuumdb: Add option for analyzing only relations missing stats.
This commit adds a new --missing-only option that can be used in
conjunction with --analyze-only and --analyze-in-stages. When this
option is specified, vacuumdb will generate ANALYZE commands for a
relation if it is missing any statistics it should ordinarily have.
For example, if a table has statistics for one column but not
another, we will analyze the whole table. A similar principle
applies to extended statistics, expression indexes, and table
inheritance.
Co-authored-by: Corey Huinker <[email protected]>
Reviewed-by: TODO
Discussion: https://postgr.es/m/Z5O1bpcwDrMgyrYy%40nathan
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/5f8eb25706b62923c53172e453c8a4dedd877a3d
Author: Nathan Bossart <[email protected]>
Modified Files
--------------
doc/src/sgml/ref/vacuumdb.sgml | 16 ++++++
src/bin/scripts/t/102_vacuumdb_stages.pl | 60 +++++++++++++++++++++
src/bin/scripts/vacuumdb.c | 92 ++++++++++++++++++++++++++++++++
src/test/perl/PostgreSQL/Test/Cluster.pm | 27 ++++++++++
4 files changed, 195 insertions(+)
view thread (3+ messages) latest in thread
reply
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: [email protected]
Cc: [email protected], [email protected]
Subject: Re: pgsql: vacuumdb: Add option for analyzing only relations missing stats.
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox