2 description "Role applied to all nominatim servers."
7 :lonvia => { :status => :administrator }
11 :members => [:lonvia, :tomh]
17 :http_rate_limit => "s:2/sec:15"
23 :max_connections => "450",
24 :synchronous_commit => "off",
25 :checkpoint_timeout => "10min",
26 :checkpoint_completion_target => "0.9",
28 :shared_buffers => "2GB",
29 :autovacuum_max_workers => "1",
30 :max_parallel_workers_per_gather => "0",
31 :maintenance_work_mem => "10GB",
32 :seq_page_cost => "3.0",
33 :random_page_cost => "3.0",
34 :effective_cache_size => "60GB",
35 :wal_level => "minimal",
36 :max_wal_senders => "0"
42 :comment => "Increase shared memory for postgres",
44 "kernel.shmmax" => 26 * 1024 * 1024 * 1024,
45 "kernel.shmall" => 26 * 1024 * 1024 * 1024 / 4096
49 :comment => "Reduce swap usage",
54 :network_conntrack_time_wait => {
55 :comment => "Only track completed connections for 30 seconds",
57 "net.netfilter.nf_conntrack_tcp_timeout_time_wait" => "30"
60 :network_conntrack_max => {
61 :comment => "Increase max number of connections tracked",
63 "net.netfilter.nf_conntrack_max" => "196608"
68 :dbadmins => %w[lonvia tomh]
73 "recipe[nominatim::default]",