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: 2026-06-04 17:14:34
Message-ID: aiGyesxrkkzG84Ty@pryzbyj2023
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Checking back.

On Wed, Aug 20, 2025 at 08:51:16PM -0500, Justin Pryzby wrote:
> 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2026-06-04 17:17:57 Re: Avoid orphaned objects dependencies, take 3
Previous Message Jeff Davis 2026-06-04 17:03:22 Re: Avoid orphaned objects dependencies, take 3

Browse pgsql-general by date

  From Date Subject
Previous Message apurba saha 2026-06-03 14:48:19 Asking suggestions on how to vectorize big texts for conceptual searching in postgresql 18