commit 8437af0af70811036752c00221f0c26676ee70f9
parent 16007d7083f70ac7b3f652b96323487903fd4dc2
Author: MTRNord <mtrnord1@gmail.com>
Date: Mon, 24 Jul 2023 14:53:21 +0200
small pg changes
Diffstat:
1 file changed, 19 insertions(+), 4 deletions(-)
diff --git a/infrastructure/configs/postgres-clusters.yaml b/infrastructure/configs/postgres-clusters.yaml
@@ -38,6 +38,11 @@ spec:
postgresql:
version: "15"
parameters:
+ # Connectivity
+ max_connections: "160"
+ superuser_reserved_connections: "3"
+
+ # Memory settings
shared_buffers: "4096 MB"
work_mem: "32 MB"
maintenance_work_mem: "320 MB"
@@ -45,39 +50,49 @@ spec:
effective_cache_size: "11 GB"
effective_io_concurrency: "150"
random_page_cost: "1.5"
+
+ # Monitoring
shared_preload_libraries: "pg_stat_statements"
track_io_timing: on
track_functions: pl
+
+ # Replication
wal_level: replica
max_wal_senders: "10"
synchronous_commit: on
+
+ # Checkpointing
checkpoint_timeout: "15 min"
checkpoint_completion_target: "0.9"
+ min_wal_size: "512 MB"
+ max_wal_size: "1024 MB"
# archive_mode: on # having it on enables activating P.I.T.R. at a later time without restart
# archive_command: "/bin/true" # not doing anything yet with WAL-s
- wal_compression: "on"
password_encryption: scram-sha-256
+
+ # WAL writing
+ wal_compression: "on"
wal_buffers: "-1"
wal_writer_delay: 200ms
wal_writer_flush_after: 1MB
wal_keep_size: "3650 MB"
- min_wal_size: "512 MB"
- max_wal_size: "1024 MB"
-
+ # Background writer
bgwriter_delay: 200ms
bgwriter_lru_maxpages: "100"
bgwriter_lru_multiplier: "2.0"
bgwriter_flush_after: "0"
+ # Parallel queries
max_worker_processes: "12"
max_parallel_workers_per_gather: "6"
max_parallel_maintenance_workers: "6"
max_parallel_workers: "12"
parallel_leader_participation: "on"
+ # Advanced features
enable_partitionwise_join: "on"
enable_partitionwise_aggregate: "on"
jit: "on"
