> On 16 Jul 2026, at 04:53, Fujii Masao <[email protected]> wrote: > > On Thu, Jul 16, 2026 at 12:42 AM Nathan Bossart > <[email protected]> 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.
I had a look at this open item today and the proposal and patch looks good to me. Just one small comment: don't we need a check for the applicable server version (as per the attached v2) before issuing ANALYZE ONLY since it's not supported in all versions? -- Daniel Gustafsson
v2-0001-vacuumdb-Use-ANALYZE-ONLY-for-partitioned-tables.patch
Description: Binary data
