Horton

v1-0001-vacuumdb-Skip-VACUUM-ONLY_DATABASE_STATS-with-ana.patch

application/octet-stream

Download
Filename: v1-0001-vacuumdb-Skip-VACUUM-ONLY_DATABASE_STATS-with-ana.patch
Type: application/octet-stream
Part: 0
Message: vacuumdb --analyze-only does not need to issue VACUUM (ONLY_DATABASE_STATS) ?

Patch

Format: format-patch
Series: patch v1-0001
Subject: vacuumdb: Skip VACUUM (ONLY_DATABASE_STATS) with --analyze-only.
File+−
src/bin/scripts/vacuumdb.c 2 1 
From 7a2dadf3a63367c465fa0eee5d9596db9409555e Mon Sep 17 00:00:00 2001
From: Fujii Masao <fujii@postgresql.org>
Date: Fri, 8 Aug 2025 15:41:36 +0900
Subject: [PATCH v1] vacuumdb: Skip VACUUM (ONLY_DATABASE_STATS) with
 --analyze-only.

---
 src/bin/scripts/vacuumdb.c | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/src/bin/scripts/vacuumdb.c b/src/bin/scripts/vacuumdb.c
index 79b1096eb08..f755c7b10e7 100644
--- a/src/bin/scripts/vacuumdb.c
+++ b/src/bin/scripts/vacuumdb.c
@@ -749,7 +749,8 @@ vacuum_one_database(ConnParams *cparams,
 	}
 
 	/* If we used SKIP_DATABASE_STATS, mop up with ONLY_DATABASE_STATS */
-	if (vacopts->skip_database_stats && stage == ANALYZE_NO_STAGE)
+	if (vacopts->skip_database_stats && stage == ANALYZE_NO_STAGE &&
+		!vacopts->analyze_only)
 	{
 		const char *cmd = "VACUUM (ONLY_DATABASE_STATS);";
 		ParallelSlot *free_slot = ParallelSlotsGetIdle(sa, NULL);
-- 
2.50.1