33 lines
843 B
Nix
33 lines
843 B
Nix
{ config, pkgs, ... }:
|
|
|
|
{
|
|
services.postgresql = {
|
|
enable = true;
|
|
settings = {
|
|
wal_level = "minimal";
|
|
max_wal_senders = 0;
|
|
fsync = false;
|
|
synchronous_commit = false;
|
|
full_page_writes = false;
|
|
wal_compression = true;
|
|
checkpoint_timeout = "1d";
|
|
checkpoint_completion_target = 0.9;
|
|
checkpoint_flush_after = 0;
|
|
min_wal_size = "32MB";
|
|
max_wal_size = "64MB";
|
|
max_connections = 100;
|
|
shared_buffers = "128MB";
|
|
effective_cache_size = "384MB";
|
|
maintenance_work_mem = "32MB";
|
|
wal_buffers = "64MB";
|
|
default_statistics_target = 100;
|
|
random_page_cost = 1.1;
|
|
effective_io_concurrency = 4;
|
|
work_mem = "32MB";
|
|
max_worker_processes = 2;
|
|
max_parallel_workers_per_gather = 1;
|
|
max_parallel_workers = 2;
|
|
};
|
|
};
|
|
}
|