X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/1b37d1344f57550285a0d3617c2fddf9795f01a7..dd623b987d2d718be15a58dbc1cacfe7e88c1636:/roles/nominatim.rb diff --git a/roles/nominatim.rb b/roles/nominatim.rb index 9564e1183..93d917e7b 100644 --- a/roles/nominatim.rb +++ b/roles/nominatim.rb @@ -5,32 +5,15 @@ default_attributes( :accounts => { :users => { :lonvia => { :status => :administrator }, - :twain => { :status => :administrator }, :nominatim => { :status => :role, - :members => [:lonvia, :tomh, :twain] + :members => [:lonvia, :tomh] } } }, - :apache => { - :mpm => "event", - :timeout => 60, - :keepalive => false, - :reqtimeout => true, - :event => { - :server_limit => 32, - :max_request_workers => 1600, - :threads_per_child => 50, - :min_spare_threads => 125, - :max_spare_threads => 925 - } - }, - :apt => { - :sources => ["postgresql"] - }, :networking => { :firewall => { - :http_rate_limit => "s:7/sec:15" + :http_rate_limit => "s:2/sec:15" } }, :postgresql => { @@ -41,8 +24,13 @@ default_attributes( :checkpoint_segments => "32", :checkpoint_timeout => "10min", :checkpoint_completion_target => "0.9", + :jit => "off", :shared_buffers => "2GB", - :autovacuum_max_workers => "1" + :autovacuum_max_workers => "1", + :max_parallel_workers_per_gather => "0", + :maintenance_work_mem => "10GB", + :random_page_cost => "1.5", + :effective_cache_size => "60GB" } } }, @@ -76,9 +64,24 @@ default_attributes( :network_conntrack_max => { :comment => "Increase max number of connections tracked", :parameters => { - "net.netfilter.nf_conntrack_max" => "131072" + "net.netfilter.nf_conntrack_max" => "196608" } } + }, + :nominatim => { + :dbadmins => %w[lonvia tomh], + :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" + } } )