flora/akkoma: fix odd postgres performance issues

dunno why these were all set so low

1 files changed, 7 insertions, 7 deletions

diff --git a/flora/services/akkoma.nix b/flora/services/akkoma.nix
index 44b5528..d7e7b49 100644
--- a/flora/services/akkoma.nix
+++ b/flora/services/akkoma.nix
@@ -114,7 +114,7 @@ in
               database = "pleroma";
               socket_dir = "/run/postgresql";
               pool_size = 10;
-              # prepare = ":named";
+              prepare = mkAtom ":named";
               show_sensitive_data_on_connection_error = true;
               parameters = { plan_cache_mode = "force_custom_plan"; };
             };
@@ -166,16 +166,16 @@ in
         } ];
 
         settings = {
-          max_connections = 20;
-          shared_buffers = "256MB";
-          effective_cache_size = "768MB";
-          maintenance_work_mem = "64MB";
+          max_connections = 300;
+          shared_buffers = "768MB";
+          effective_cache_size = "2304MB";
+          maintenance_work_mem = "192MB";
           checkpoint_completion_target = 0.9;
-          wal_buffers = "7864kB";
+          wal_buffers = "16MB";
           default_statistics_target = 100;
           random_page_cost = 1.1;
           effective_io_concurrency = 200;
-          work_mem = "6553kB";
+          work_mem = "4MB";
           huge_pages = "off";
           min_wal_size = "2GB";
           max_wal_size = "8GB";