From 1e2d08072b1fb363b2ba63c6ea969bda729d5363 Mon Sep 17 00:00:00 2001
From: Nguyễn Gia Phong <mcsinyx@disroot.org>
Date: Thu, 16 Feb 2023 13:52:38 +0900
Subject: Upgrade to PostgreSQL 15 and tune a bit

---
 matrix.nix | 15 ++++++++++++++-
 1 file changed, 14 insertions(+), 1 deletion(-)

(limited to 'matrix.nix')

diff --git a/matrix.nix b/matrix.nix
index e883918..b3bc773 100644
--- a/matrix.nix
+++ b/matrix.nix
@@ -111,7 +111,20 @@ in {
           ensurePermissions."DATABASE dendrite" = "ALL PRIVILEGES";
         }
       ];
-      package = pkgs.postgresql_14;
+      package = pkgs.postgresql_15;
+      settings = {
+        checkpoint_timeout = "5min";
+        effective_cache_size = "1GB";
+        effective_io_concurrency = 100;
+        maintenance_work_mem = "320MB";
+        max_parallel_maintenance_workers = 4;
+        max_parallel_workers_per_gather = 4;
+        max_wal_senders = 0;
+        random_page_cost = 1.25;
+        shared_buffers = "512MB";
+        wal_buffers = -1;
+        work_mem = "32MB";
+      };
     };
   };
 
-- 
cgit 1.4.1