X-Git-Url: https://git.openstreetmap.org/chef.git/blobdiff_plain/f2e8efe99b471cd5aef85977e6b22d024151c9a4..198ff0c7f1b14a48cc482add12a378ccabcaf61f:/roles/nominatim.rb diff --git a/roles/nominatim.rb b/roles/nominatim.rb index ac76db744..93d917e7b 100644 --- a/roles/nominatim.rb +++ b/roles/nominatim.rb @@ -5,29 +5,17 @@ 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 + :networking => { + :firewall => { + :http_rate_limit => "s:2/sec:15" } }, - :apt => { - :sources => ["postgresql"] - }, :postgresql => { :settings => { :defaults => { @@ -36,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" } } }, @@ -71,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" + } } )