config/server/databases/postgresql.nix at main

encode42.dev / nixos

fork atom

Personal-use NixOS configuration

fork atom

nixos / config / server / databases / postgresql.nix

at main 20 lines 304 B view raw

wrap content

encode42.dev Move software and package configurations to `config` 15d ago

e163a950

 1{ pkgs, ... }:
 2
 3{
 4  services.postgresql = {
 5    enable = true;
 6
 7    enableJIT = true;
 8
 9    settings = {
10      random_page_cost = 1.2;
11
12      jit_above_cost = 500000;
13
14      autovacuum_vacuum_cost_limit = 2000;
15      autovacuum_vacuum_scale_factor = 0.01;
16    };
17
18    package = pkgs.postgresql_17;
19  };
20}