Don't reset relhasindex for partitioned tables on ANALYZE Commit 0e69f705cc1a introduced code to analyze partitioned table; however, that code fails to preserve pg_class.relhasindex correctly. Fix by observing whether any indexes exist rather than accidentally falling through to assuming none do.
Backpatch to 14. Author: Alexander Pyhalov <[email protected]> Reviewed-by: Álvaro Herrera <[email protected]> Reviewed-by: Zhihong Yu <[email protected]> Discussion: https://postgr.es/m/calnj-vs1r3qoe5t4tbzxrkpbtzrbpq1ddcw4rma_a+oqwef...@mail.gmail.com Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/be280cdad2985749e558212b0a5c8bdf9abb4e6a Modified Files -------------- src/backend/commands/analyze.c | 32 +++++++++++++++++++++++--------- src/test/regress/expected/vacuum.out | 22 ++++++++++++++++++++++ src/test/regress/sql/vacuum.sql | 16 ++++++++++++++++ 3 files changed, 61 insertions(+), 9 deletions(-)
