tilecache: block 9db.jp referer

[chef.git] / cookbooks / postgresql / attributes / default.rb

diff --git a/cookbooks/postgresql/attributes/default.rb b/cookbooks/postgresql/attributes/default.rb
index 6a5d68641d10bd0cd653ce311e6fd58a30851276..91ffbea5e7b227cf3e9fb4de81cd3b8e0fe363c4 100644 (file)
--- 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"
@@ -28,7 +29,11 @@ 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][:autovacuum_vacuum_scale_factor] = "0.2"
+default[:postgresql][:settings][:defaults][:autovacuum_analyze_scale_factor] = "0.1"
 default[:postgresql][:settings][:defaults][:user_name_maps] = {}
 default[:postgresql][:settings][:defaults][:early_authentication_rules] = []
 default[:postgresql][:settings][:defaults][:late_authentication_rules] = []
 default[:postgresql][:settings][:defaults][:standby_mode] = "off"
+
+default[:apt][:sources] = node[:apt][:sources] | ["postgresql"]