Re: analyze-in-stages post upgrade questions

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Nathan Bossart <nathandbossart(at)gmail(dot)com>
Cc: Justin Pryzby <pryzby(at)telsasoft(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-16 02:53:08
Message-ID: CAHGQGwHLMxQbsKK4JKM1pPopSgXixNkrQex8siJstDSo574bbA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Thu, Jul 16, 2026 at 12:42 AM Nathan Bossart
<nathandbossart(at)gmail(dot)com> wrote:
>
> [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].

Thanks for pointing this out!

> Is it appropriate to consider
> this v19 stabilization work?

Yes, probably. The attached patch updates vacuumdb to use ANALYZE ONLY
for partitioned tables when --analyze-only or --analyze-in-stages is
specified, as suggested.

Regards,

--
Fujii Masao

Attachment Content-Type Size
v1-0001-vacuumdb-Use-ANALYZE-ONLY-for-partitioned-tables.patch application/octet-stream 12.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2026-07-16 02:58:28 Re: sequencesync worker race with REFRESH SEQUENCES
Previous Message Chao Li 2026-07-16 02:49:59 Re: tablecmds: fix bug where index rebuild loses replica identity on partitions

Browse pgsql-general by date

  From Date Subject
Previous Message Laurenz Albe 2026-07-15 21:20:30 Re: Transaction Isolation level for ERP software