X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/c389f176ac7a568bedaa7bdd690438b72ecf35bf..4460d5825cf9542ba7f927618bee5ce8e4ae5ff5:/roles/tile.rb diff --git a/roles/tile.rb b/roles/tile.rb index be27fe163..ac642a758 100644 --- a/roles/tile.rb +++ b/roles/tile.rb @@ -14,14 +14,11 @@ default_attributes( :mpm => "event", :timeout => 60, :event => { - :server_limit => 80, - :max_request_workers => 1200, :threads_per_child => 20, :min_spare_threads => 300, - :max_spare_threads => 1200, :max_connections_per_child => 0, :async_request_worker_factor => 4, - :listen_cores_buckets_ratio => 6 + :listen_cores_buckets_ratio => 8 } }, :munin => { @@ -37,14 +34,17 @@ default_attributes( :settings => { :defaults => { :max_connections => "250", - :temp_buffers => "32MB", + :shared_buffers => "16GB", :work_mem => "128MB", + :maintenance_work_mem => "8GB", :max_parallel_workers_per_gather => "0", + :wal_level => "minimal", :wal_buffers => "1024kB", :wal_writer_delay => "500ms", + :checkpoint_timeout => "60min", :commit_delay => "10000", - :max_wal_size => "2880MB", - :random_page_cost => "1.1", + :max_wal_size => "10GB", + :max_wal_senders => "0", :jit => "off", :track_activity_query_size => "16384", :autovacuum_vacuum_scale_factor => "0.05",