X-Git-Url: https://git.openstreetmap.org/chef.git/blobdiff_plain/64c6dceeb0b459f9adf0abe6f9188d3311bc9816..c739082a9748851e2f4242ee846885be5bb89dc2:/roles/pummelzacken.rb diff --git a/roles/pummelzacken.rb b/roles/pummelzacken.rb index 931320eb5..b7ae7b32b 100644 --- a/roles/pummelzacken.rb +++ b/roles/pummelzacken.rb @@ -22,17 +22,18 @@ default_attributes( :versions => [ "9.3" ], :settings => { :defaults => { - :shared_buffers => "32GB", + :shared_buffers => "10GB", :work_mem => "160MB", - :maintenance_work_mem => "10GB", + :maintenance_work_mem => "20GB", :random_page_cost => "1.5", :effective_cache_size => "60GB", - :fsync => "on" + :fsync => "off" } } }, :nominatim => { :enabled => false, + :flatnode_file => "/ssd/nominatim/nodes.store", :database => { :cluster => "9.3/main", :dbname => "nominatim", @@ -49,6 +50,18 @@ default_attributes( :pm => "static", :max_children => "10" } + }, + :tablespaces => { + "Osm2pgsql_Data" => "ssd", + "Osm2pgsql_Index" => "ssd", + "Place_Data" => "ssd", + "Place_Index" => "ssd", + "Address_Data" => "ssd", + "Address_Index" => "ssd", + "Search_Data" => "ssd", + "Search_Index" => "ssd", + "Aux_Data" => "data", + "Aux_Index" => "data", } } )