From 63750daa63f07dc57e5a95d3343452f58a48f7f6 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Jani=20V=C3=A4limaa?= Date: Sun, 11 May 2025 12:14:36 +0300 Subject: Increase PostgreSQL server shared_buffers to 4GB According to upstream a reasonable starting value for shared_buffers is 25% of the memory which would be actually 8GB in sucuk. --- modules/postgresql/templates/postgresql.conf | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'modules/postgresql') diff --git a/modules/postgresql/templates/postgresql.conf b/modules/postgresql/templates/postgresql.conf index bc5caa09..bc13ace4 100644 --- a/modules/postgresql/templates/postgresql.conf +++ b/modules/postgresql/templates/postgresql.conf @@ -113,7 +113,7 @@ ssl = on # - Memory - -shared_buffers = 24MB # min 128kB +shared_buffers = 4096MB # min 128kB # (change requires restart) #temp_buffers = 8MB # min 800kB #max_prepared_transactions = 0 # zero disables the feature -- cgit v1.2.1