Horton

vacuumdb: Do not run VACUUM (ONLY_DATABASE_STATS) when --analyze-only.

Fujii Masao <fujii@postgresql.org>

View on postgr.es
Commit: 879c492480d0e9ad8155c4269f95c5e8add41901
Author: Fujii Masao <fujii@postgresql.org>
Date: 2025-09-24T16:38:54Z
Releases: 19 (unreleased) 
vacuumdb: Do not run VACUUM (ONLY_DATABASE_STATS) when --analyze-only.

Previously, vacuumdb --analyze-only issued VACUUM (ONLY_DATABASE_STATS)
at the end. Since --analyze-only is meant to update optimizer statistics only,
this extra VACUUM command is unnecessary.

This commit prevents vacuumdb --analyze-only from running that redundant
VACUUM command.

Author: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: Mircea Cadariu <cadariu.mircea@gmail.com>
Discussion: https://postgr.es/m/CAHGQGwEqHGa-k=wbRMucUVihHVXk4NQkK94GNN=ym9cQ5HBSHg@mail.gmail.com

Files

PathChange+/−
src/bin/scripts/t/100_vacuumdb.pl modified +6 −0
src/bin/scripts/vacuumdb.c modified +2 −1

Discussion