From 98768a3c592475aac0db405cf460bf0cc961e0b8 Mon Sep 17 00:00:00 2001 From: Rory& Date: Mon, 5 Feb 2024 14:04:44 +0100 Subject: Postgres buffering, maybe? --- host/Rory-nginx/services/postgres.nix | 17 ++++++++++++++++- modules/software-templates/dotnet.nix | 2 +- 2 files changed, 17 insertions(+), 2 deletions(-) diff --git a/host/Rory-nginx/services/postgres.nix b/host/Rory-nginx/services/postgres.nix index 26ceed7..8912542 100755 --- a/host/Rory-nginx/services/postgres.nix +++ b/host/Rory-nginx/services/postgres.nix @@ -24,9 +24,24 @@ dataDir = "/mnt/postgres/data"; settings = { "max_connections" = "100"; - "shared_buffers" = "128MB"; + "shared_buffers" = "512MB"; + "effective_cache_size" = "8192MB"; "max_wal_size" = "1GB"; "min_wal_size" = "80MB"; + "work_mem" = "16MB"; + "maintenance_work_mem" = "256MB"; + "checkpoint_segments" = "64"; + "default_statistics_target" = "250"; + + # can use this to view stats: SELECT query, total_time, calls, rows FROM pg_stat_statements ORDER BY total_time DESC LIMIT 10; + "shared_preload_libraries" = "pg_stat_statements"; + "pg_stat_statements.max" = "10000"; + "pg_stat_statements.track" = "all"; + + #we're on virtualised HDDs... + "random_page_cost" = "2.0"; + "synchronous_commit" = "off"; + }; }; diff --git a/modules/software-templates/dotnet.nix b/modules/software-templates/dotnet.nix index 8a8c1b5..9abe797 100644 --- a/modules/software-templates/dotnet.nix +++ b/modules/software-templates/dotnet.nix @@ -8,4 +8,4 @@ DOTNET_CLI_TELEMETRY_OPTOUT = "1"; DOTNET_ROOT = "${(callPackage ../packages/dotnet-pack.nix { inherit pkgs; })}"; }; -}e \ No newline at end of file +} \ No newline at end of file -- cgit 1.4.1