commit 3daa329f6bfd6f28272c2105e4c253b1e53cc88e parent ae5ac6de9653f85a533cdf43a41f441b6ea00d5e Author: MTRNord <mtrnord1@gmail.com> Date: Thu, 25 Jan 2024 14:36:06 +0100 More small tweaks Diffstat:
| M | infrastructure/configs/postgres-clusters.yaml | | | 6 | +++--- |
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/infrastructure/configs/postgres-clusters.yaml b/infrastructure/configs/postgres-clusters.yaml @@ -47,12 +47,12 @@ spec: # Memory settings shared_buffers: "4GB" - work_mem: "32 MB" + work_mem: "64 MB" maintenance_work_mem: "1GB" huge_pages: off effective_cache_size: "11 GB" - effective_io_concurrency: "150" - random_page_cost: "1.5" + effective_io_concurrency: "100" + random_page_cost: "1.1" # Cost of a sequentially-fetched disk page seq_page_cost: "0.7"