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}
encode42.dev