diff options
Diffstat (limited to 'host/Rory-nginx/services')
| -rwxr-xr-x | host/Rory-nginx/services/postgres.nix | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/host/Rory-nginx/services/postgres.nix b/host/Rory-nginx/services/postgres.nix index a05aa1e..b63e437 100755 --- a/host/Rory-nginx/services/postgres.nix +++ b/host/Rory-nginx/services/postgres.nix @@ -32,13 +32,13 @@ max_connections = 2500; superuser_reserved_connections = 3; - shared_buffers = "32565MB"; - work_mem = "512MB"; - maintenance_work_mem = "1024MB"; + shared_buffers = "32GB"; + work_mem = "1GB"; + maintenance_work_mem = "8GB"; huge_pages = "try"; - effective_cache_size = "60GB"; # was 22 - effective_io_concurrency = "8"; - random_page_cost = 4; + effective_cache_size = "64GB"; # was 22 + effective_io_concurrency = 100; + random_page_cost = 1.1; # 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"; @@ -49,12 +49,12 @@ wal_level = "replica"; max_wal_senders = 0; - synchronous_commit = "off"; # was on + synchronous_commit = "off"; # was ond3 checkpoint_timeout = "15min"; checkpoint_completion_target = "0.9"; - max_wal_size = "1GB"; - min_wal_size = "512MB"; + max_wal_size = "2GB"; + min_wal_size = "1GB"; wal_compression = "on"; wal_buffers = "-1"; |