Re: analyze-in-stages post upgrade questions

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Mircea Cadariu <cadariu(dot)mircea(at)gmail(dot)com>, "Zechman, Derek S" <Derek(dot)S(dot)Zechman(at)snapon(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: analyze-in-stages post upgrade questions
Date: 2025-08-21 01:51:16
Message-ID: aKZ7lMYGnnIo35c0@pryzbyj2023
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

When analyzing a partitioned table, I think you should use ANALYZE ONLY,
or otherwise avoid processing the children twice.

Thanks for handling this. I was recently suprised to learn that
vacuumdb doesn't process parents.

--
Justin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrey Borodin 2025-08-21 02:07:16 Re: VM corruption on standby
Previous Message Peter Smith 2025-08-21 01:10:24 Re: Remove redundant assignment of a variable in function AlterPublicationTables

Browse pgsql-general by date

  From Date Subject
Previous Message Adrian Klaver 2025-08-20 23:00:42 Re: MS SQL to Postgres