From 8c40e0d0f46a641bdce723642f31ac1cfb6c26b4 Mon Sep 17 00:00:00 2001
From: Joe Banks <joe@jb3.dev>
Date: Sat, 27 Apr 2024 00:39:55 +0100
Subject: Upgrade to PostgreSQL 16 and move to databases namespace

---
 .../namespaces/databases/postgresql/configmap.yaml | 29 ++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100644 kubernetes/namespaces/databases/postgresql/configmap.yaml

(limited to 'kubernetes/namespaces/databases/postgresql/configmap.yaml')

diff --git a/kubernetes/namespaces/databases/postgresql/configmap.yaml b/kubernetes/namespaces/databases/postgresql/configmap.yaml
new file mode 100644
index 0000000..12ad19b
--- /dev/null
+++ b/kubernetes/namespaces/databases/postgresql/configmap.yaml
@@ -0,0 +1,29 @@
+apiVersion: v1
+kind: ConfigMap
+metadata:
+  name: postgres-config
+  namespace: databases
+data:
+  postgresql.conf: |
+    # From pgtune
+    max_connections = 110
+    shared_buffers = 1536MB
+    effective_cache_size = 4608MB
+    maintenance_work_mem = 384MB
+    checkpoint_completion_target = 0.9
+    wal_buffers = 16MB
+    default_statistics_target = 100
+    random_page_cost = 1.1
+    effective_io_concurrency = 200
+    work_mem = 3574kB
+    min_wal_size = 1GB
+    max_wal_size = 4GB
+    max_worker_processes = 4
+    max_parallel_workers_per_gather = 2
+    max_parallel_workers = 4
+    max_parallel_maintenance_workers = 2
+
+    # Custom conf
+    listen_addresses = '*'
+    password_encryption = md5
+    shared_preload_libraries = 'pg_stat_statements'	# (change requires restart)
-- 
cgit v1.2.3