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 <[email protected]> Reviewed-by: Corey Huinker <[email protected]> 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(-)
