v31-0012-Revert-the-update-for-the-minimum-value-of-maint.patch

application/octet-stream

Filename: v31-0012-Revert-the-update-for-the-minimum-value-of-maint.patch
Type: application/octet-stream
Part: 10
Message: Re: [PoC] Improve dead tuple storage for lazy vacuum

Patch

Format: format-patch
Series: patch v31-0012
Subject: Revert the update for the minimum value of maintenance_work_mem.
File+
src/backend/postmaster/autovacuum.c 3 3
src/backend/utils/misc/guc_tables.c 1 1
From 8080e74de8597b6e8567fbfce5dbd2771937287c Mon Sep 17 00:00:00 2001
From: Masahiko Sawada <sawada.mshk@gmail.com>
Date: Wed, 8 Mar 2023 15:09:22 +0900
Subject: [PATCH v31 12/14] Revert the update for the minimum value of
 maintenance_work_mem.

---
 src/backend/postmaster/autovacuum.c | 6 +++---
 src/backend/utils/misc/guc_tables.c | 2 +-
 2 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/src/backend/postmaster/autovacuum.c b/src/backend/postmaster/autovacuum.c
index 60caeae739..c0e2e00a7e 100644
--- a/src/backend/postmaster/autovacuum.c
+++ b/src/backend/postmaster/autovacuum.c
@@ -3399,12 +3399,12 @@ check_autovacuum_work_mem(int *newval, void **extra, GucSource source)
 		return true;
 
 	/*
-	 * We clamp manually-set values to at least 2MB.  Since
+	 * We clamp manually-set values to at least 1MB.  Since
 	 * maintenance_work_mem is always set to at least this value, do the same
 	 * here.
 	 */
-	if (*newval < 2048)
-		*newval = 2048;
+	if (*newval < 1024)
+		*newval = 1024;
 
 	return true;
 }
diff --git a/src/backend/utils/misc/guc_tables.c b/src/backend/utils/misc/guc_tables.c
index 8a64614cd1..1c0583fe26 100644
--- a/src/backend/utils/misc/guc_tables.c
+++ b/src/backend/utils/misc/guc_tables.c
@@ -2313,7 +2313,7 @@ struct config_int ConfigureNamesInt[] =
 			GUC_UNIT_KB
 		},
 		&maintenance_work_mem,
-		65536, 2048, MAX_KILOBYTES,
+		65536, 1024, MAX_KILOBYTES,
 		NULL, NULL, NULL
 	},
 
-- 
2.31.1