- :postgresql => {
- :versions => ["9.5"],
- :settings => {
- :defaults => {
- :work_mem => "300MB",
- :maintenance_work_mem => "10GB",
- :random_page_cost => "1.5",
- :effective_cache_size => "60GB",
- :fsync => "off"
- }
- }
- },
- :nominatim => {
- :state => "off",
- :dbadmins => %w(lonvia tomh),
- :dbcluster => "9.5/main",
- :flatnode_file => "/ssd/nominatim/nodes.store",
- :logdir => "/ssd/nominatim/log",
- :tablespaces => {
- "dosm" => "/ssd/tablespaces/dosm",
- "iosm" => "/ssd/tablespaces/iosm",
- "dplace" => "/ssd/tablespaces/dplace",
- "iplace" => "/ssd/tablespaces/iplace",
- "daddress" => "/ssd/tablespaces/daddress",
- "iaddress" => "/ssd/tablespaces/iaddress",
- "dsearch" => "/ssd/tablespaces/dsearch",
- "isearch" => "/ssd/tablespaces/isearch",
- "daux" => "/ssd/tablespaces/daux",
- "iaux" => "/ssd/tablespaces/iaux"
- }
- },
- :sysfs => {
- :md_tune => {
- :comment => "Enable request merging for NVMe devices",
- :parameters => {
- "block/nvme0n1/queue/nomerges" => "1",
- "block/nvme1n1/queue/nomerges" => "1"