diff options
| author |  Joe Banks <[email protected]> | 2024-04-27 00:39:55 +0100 |
|---|---|---|
| committer | Joe Banks <[email protected]> | 2024-04-27 16:15:07 +0100 |
| commit | 8c40e0d0f46a641bdce723642f31ac1cfb6c26b4 (patch) | |
| tree | d43ad4d5a739c19e5a1de0eae64841fc729e60b3 /kubernetes/namespaces/databases/postgresql/configmap.yaml | |
| parent | Update pixels redis secret (diff) | |
Upgrade to PostgreSQL 16 and move to databases namespace
Diffstat (limited to 'kubernetes/namespaces/databases/postgresql/configmap.yaml')
| -rw-r--r-- | kubernetes/namespaces/databases/postgresql/configmap.yaml | 29 |
1 files changed, 29 insertions, 0 deletions
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) |