diff options
| author |  Chris Lovering <[email protected]> | 2024-04-27 21:49:54 +0100 |
|---|---|---|
| committer |  jchristgit <[email protected]> | 2024-04-29 19:51:00 +0200 |
| commit | 147a7848b83334dc272d1dc5200fd26495ff53f8 (patch) | |
| tree | 82727c2e328217b3c23b0583d74ad4eb2ca79490 | |
| parent | update access table to netcup servers (diff) | |
Updated postgres config from PGTune
| -rw-r--r-- | kubernetes/namespaces/databases/postgresql/configmap.yaml | 13 |
1 files changed, 11 insertions, 2 deletions
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 |