Upgrade to PostgreSQL 15 and tune a bit

1 files changed, 14 insertions, 1 deletions

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";
+      };
     };
   };