Re: analyze-in-stages post upgrade questions - Mailing list pgsql-hackers

On Thu, Jul 16, 2026 at 12:42 AM Nathan Bossart
<nathandbossart@gmail.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