| From: | Nathan Bossart <nathan(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: vacuumdb: Fix --missing-stats-only for partitioned indexes. |
| Date: | 2026-06-17 14:19:05 |
| Message-ID: | E1wZr6f-000jLg-1i@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
vacuumdb: Fix --missing-stats-only for partitioned indexes.
The current form of the catalog query picks up partitioned tables
with expression indexes that lack statistics. However, since such
indexes never have statistics, there's no point in analyzing them.
To fix, adjust the relevant part of the query to skip partitioned
tables with expression indexes. While at it, remove the nearby
stainherit check; entries for index expressions always have
stainherit = false.
Author: Baji Shaik <baji(dot)pgdev(at)gmail(dot)com>
Reviewed-by: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
Discussion: https://postgr.es/m/CA%2Bfm-RPE1tEc6CUUPDyRbYTz9tF5Kw47nnk-Zq%3DyYvanbsxyCQ%40mail.gmail.com
Backpatch-through: 18
Branch
------
REL_18_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/7e085aabd5759c73d25556a5963866d5beaea5cd
Modified Files
--------------
src/bin/scripts/t/100_vacuumdb.pl | 1 +
src/bin/scripts/vacuumdb.c | 4 ++--
2 files changed, 3 insertions(+), 2 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2026-06-17 15:04:56 | pgsql: jsonb_plperl, jsonb_plpython: Fix unguarded recursion and loops. |
| Previous Message | Michael Paquier | 2026-06-17 07:10:56 | pgsql: Fix pgstat_count_io_op_time() calls passing incorrect informatio |