X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/2bfb0ef07fb64314f5c4ded641a8c280df9c1d0b..61e5c3aacf4ef124c48ba679b2c55f24ca1a3bea:/roles/db.rb diff --git a/roles/db.rb b/roles/db.rb index 7ff450b2f..ff308c8e5 100644 --- a/roles/db.rb +++ b/roles/db.rb @@ -41,15 +41,16 @@ default_attributes( :listen_addresses => "*", :max_connections => "1500", :max_stack_depth => "7MB", - :checkpoint_segments => "32", + :wal_level => "logical", :max_wal_size => "1536MB", :checkpoint_completion_target => "0.8", + :max_wal_senders => "10", :cpu_tuple_cost => "0.1", + :jit => "off", :log_min_duration_statement => "1000", :late_authentication_rules => [ - { :address => "10.0.32.0/20" }, - { :address => "10.0.48.0/20" }, - { :address => "10.0.64.0/20" } + { :address => "10.0.48.0/20" }, # amsterdam + { :address => "10.0.64.0/20" } # dublin ] } }