pgsql: vacuumdb: Fix --missing-stats-only for partitioned indexes.

Поиск
Список
Период
Сортировка
Искать

pgsql: vacuumdb: Fix --missing-stats-only for partitioned indexes.

От:
Nathan Bossart <nathan@postgresql.org>
Дата:
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 
Reviewed-by: Corey Huinker 
Discussion: https://postgr.es/m/CA%2Bfm-RPE1tEc6CUUPDyRbYTz9tF5Kw47nnk-Zq%3DyYvanbsxyCQ%40mail.gmail.com
Backpatch-through: 18

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/d2cea63065b3684d2d1eba4c3f4dea68bf1b373c

Modified Files
--------------
src/bin/scripts/t/100_vacuumdb.pl | 1 +
src/bin/scripts/vacuuming.c       | 4 ++--
2 files changed, 3 insertions(+), 2 deletions(-)

FAQ