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 ++++++++++++++++- 1 file changed, 16 insertions(+), 1 deletion(-) (limited to 'host') 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"; + }; }; -- cgit 1.4.1