X-Git-Url: https://git.openstreetmap.org/chef.git/blobdiff_plain/846b489e99b9e5237dd230d19da419be88635677..c276a3a197cfe8a2e606c0b0eb606f5afeaae132:/cookbooks/postgresql/attributes/default.rb?ds=sidebyside diff --git a/cookbooks/postgresql/attributes/default.rb b/cookbooks/postgresql/attributes/default.rb index 42939d7cd..5829b9fe3 100644 --- a/cookbooks/postgresql/attributes/default.rb +++ b/cookbooks/postgresql/attributes/default.rb @@ -7,6 +7,7 @@ default[:postgresql][:settings][:defaults][:temp_buffers] = "8MB" default[:postgresql][:settings][:defaults][:work_mem] = "1MB" default[:postgresql][:settings][:defaults][:maintenance_work_mem] = "16MB" default[:postgresql][:settings][:defaults][:max_stack_depth] = "2MB" +default[:postgresql][:settings][:defaults][:effective_io_concurrency] = "1" default[:postgresql][:settings][:defaults][:wal_level] = "minimal" default[:postgresql][:settings][:defaults][:fsync] = "on" default[:postgresql][:settings][:defaults][:synchronous_commit] = "on" @@ -26,6 +27,7 @@ default[:postgresql][:settings][:defaults][:random_page_cost] = "4.0" default[:postgresql][:settings][:defaults][:cpu_tuple_cost] = "0.01" default[:postgresql][:settings][:defaults][:effective_cache_size] = "128MB" default[:postgresql][:settings][:defaults][:log_min_duration_statement] = "-1" +default[:postgresql][:settings][:defaults][:track_activity_query_size] = "1024" default[:postgresql][:settings][:defaults][:autovacuum_max_workers] = "3" default[:postgresql][:settings][:defaults][:user_name_maps] = {} default[:postgresql][:settings][:defaults][:early_authentication_rules] = []