public inbox for [email protected]
help / color / mirror / Atom feedFrom: Justin Pryzby <[email protected]>
To: Fujii Masao <[email protected]>
Cc: Laurenz Albe <[email protected]>
Cc: Mircea Cadariu <[email protected]>
Cc: Zechman, Derek S <[email protected]>
Cc: Adrian Klaver <[email protected]>
Cc: [email protected]
Subject: Re: analyze-in-stages post upgrade questions
Date: Wed, 20 Aug 2025 20:51:16 -0500
Message-ID: <aKZ7lMYGnnIo35c0@pryzbyj2023> (raw)
In-Reply-To: <CAHGQGwFS1uLe1U_edWDbxrCbqhrmqV1ag9WXWoFPuuK2YB3A8g@mail.gmail.com>
References: <[email protected]>
<CAHGQGwEvwpydO7hjnB51Q2zgS0ydv31X4HCFLNzMeqLr=poS8w@mail.gmail.com>
<[email protected]>
<CAHGQGwEj8PCk1OVveJ_F1sj_COrV95N-mfu_tLUn4gdcAM24kA@mail.gmail.com>
<[email protected]>
<CAHGQGwGje3mv5sOmyCJ0NroNPF8938OYCOHMJZbegTekccZZ=g@mail.gmail.com>
<[email protected]>
<CAHGQGwHpA8nJfnX1Tk8CiVRUuZofACUFRHwk-8i=9yHYtmqiTw@mail.gmail.com>
<[email protected]>
<CAHGQGwFS1uLe1U_edWDbxrCbqhrmqV1ag9WXWoFPuuK2YB3A8g@mail.gmail.com>
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
view thread (19+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: analyze-in-stages post upgrade questions
In-Reply-To: <aKZ7lMYGnnIo35c0@pryzbyj2023>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox