1 files changed, 28 insertions, 0 deletions
diff --git a/kubernetes/namespaces/default/postgresql/configmap.yaml b/kubernetes/namespaces/default/postgresql/configmap.yaml
new file mode 100644
index 0000000..a2c9a4e
--- /dev/null
+++ b/kubernetes/namespaces/default/postgresql/configmap.yaml
@@ -0,0 +1,28 @@
+apiVersion: v1
+kind: ConfigMap
+metadata:
+  name: postgres-config
+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)