From: | John Naylor <john(dot)naylor(at)postgresql(dot)org> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: vacuumdb: Add option for analyzing only relations missing stats. |
Date: | 2025-03-07 03:29:28 |
Message-ID: | E1tqOOu-001BoX-1t@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
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 <corey(dot)huinker(at)gmail(dot)com>
Reviewed-by: TODO
Discussion: https://postgr.es/m/Z5O1bpcwDrMgyrYy%40nathan
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/5f8eb25706b62923c53172e453c8a4dedd877a3d
Author: Nathan Bossart <nathan(at)postgresql(dot)org>
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(+)
From | Date | Subject | |
---|---|---|---|
Next Message | John Naylor | 2025-03-07 03:36:17 | Re: pgsql: vacuumdb: Add option for analyzing only relations missing stats. |
Previous Message | Michael Paquier | 2025-03-06 23:13:38 | pgsql: Fix race condition in TAP test 007_pre_auth |