diff options
| -rw-r--r-- | matrix.nix | 15 |
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"; + }; }; }; |