Re: analyze-in-stages post upgrade questions

From: Nathan Bossart <nathandbossart(at)gmail(dot)com>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, 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-07-15 15:42:25
Message-ID: aleqYZGaU4RcHemR@nathan
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

[RMT hat]

On Thu, Jun 04, 2026 at 12:14:34PM -0500, Justin Pryzby wrote:
> 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.

This is listed as an open item for v19 [0]. Is it appropriate to consider
this v19 stabilization work?

[0] https://wiki.postgresql.org/wiki/PostgreSQL_19_Open_Items

--
nathan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Bossart 2026-07-15 15:44:54 Re: [PATCH] Rebuild CHECK constraints after generated column SET EXPRESSION
Previous Message jian he 2026-07-15 15:40:33 Re: implement CAST(expr AS type FORMAT 'template')

Browse pgsql-general by date

  From Date Subject
Previous Message Gabriel Furstenheim Milerud 2026-07-14 11:06:02 pg-jason-validator a Macro Based json validation extension