:defaults => {
:max_connections => "450",
:synchronous_commit => "off",
- :checkpoint_segments => "32",
:checkpoint_timeout => "10min",
:checkpoint_completion_target => "0.9",
:jit => "off",
:autovacuum_max_workers => "1",
:max_parallel_workers_per_gather => "0",
:maintenance_work_mem => "10GB",
- :random_page_cost => "1.5",
- :effective_cache_size => "60GB"
+ :seq_page_cost => "3.0",
+ :random_page_cost => "3.0",
+ :effective_cache_size => "60GB",
+ :wal_level => "minimal",
+ :max_wal_senders => "0"
}
}
},
},
:nominatim => {
:dbadmins => %w[lonvia tomh],
+ :revision => "deploy",
:tablespaces => {
"dosm" => "/ssd/tablespaces/dosm",
"iosm" => "/ssd/tablespaces/iosm",