X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/c001915de111558b8d4a1c27f3a95dc20cc2eaca..0a6889527f95e185d70a5f3a8fc916114b1a109c:/roles/nominatim.rb diff --git a/roles/nominatim.rb b/roles/nominatim.rb index 8981e500a..b43ffbc4f 100644 --- a/roles/nominatim.rb +++ b/roles/nominatim.rb @@ -21,13 +21,17 @@ default_attributes( :defaults => { :max_connections => "450", :synchronous_commit => "off", - :checkpoint_segments => "32", :checkpoint_timeout => "10min", :checkpoint_completion_target => "0.9", :jit => "off", :shared_buffers => "2GB", :autovacuum_max_workers => "1", - :max_parallel_workers_per_gather => "0" + :max_parallel_workers_per_gather => "0", + :maintenance_work_mem => "10GB", + :random_page_cost => "1.5", + :effective_cache_size => "60GB", + :wal_level => "minimal", + :max_wal_senders => "0" } } }, @@ -39,13 +43,6 @@ default_attributes( "kernel.shmall" => 26 * 1024 * 1024 * 1024 / 4096 } }, - :kernel_scheduler_tune => { - :comment => "Tune kernel scheduler preempt", - :parameters => { - "kernel.sched_min_granularity_ns" => 10000000, - "kernel.sched_wakeup_granularity_ns" => 15000000 - } - }, :swappiness => { :comment => "Reduce swap usage", :parameters => { @@ -64,6 +61,21 @@ default_attributes( "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" + } } )