From 147a7848b83334dc272d1dc5200fd26495ff53f8 Mon Sep 17 00:00:00 2001 From: Chris Lovering Date: Sat, 27 Apr 2024 21:49:54 +0100 Subject: Updated postgres config from PGTune --- kubernetes/namespaces/databases/postgresql/configmap.yaml | 13 +++++++++++-- 1 file changed, 11 insertions(+), 2 deletions(-) (limited to 'kubernetes/namespaces/databases') diff --git a/kubernetes/namespaces/databases/postgresql/configmap.yaml b/kubernetes/namespaces/databases/postgresql/configmap.yaml index 12ad19b..4c66ab1 100644 --- a/kubernetes/namespaces/databases/postgresql/configmap.yaml +++ b/kubernetes/namespaces/databases/postgresql/configmap.yaml @@ -5,7 +5,15 @@ metadata: namespace: databases data: postgresql.conf: | - # From pgtune + # From pgtune https://pgtune.leopard.in.ua/ + # DB Version: 16 + # OS Type: linux + # DB Type: web + # Total Memory (RAM): 6 GB + # CPUs num: 4 + # Connections num: 110 + # Data Storage: ssd + max_connections = 110 shared_buffers = 1536MB effective_cache_size = 4608MB @@ -15,7 +23,8 @@ data: default_statistics_target = 100 random_page_cost = 1.1 effective_io_concurrency = 200 - work_mem = 3574kB + work_mem = 7149kB + huge_pages = off min_wal_size = 1GB max_wal_size = 4GB max_worker_processes = 4 -- cgit v1.2.3