Set effective_io_concurrency to 256 on karm

diff --git a/cookbooks/postgresql/attributes/default.rb b/cookbooks/postgresql/attributes/default.rb
index 6a5d68641d10bd0cd653ce311e6fd58a30851276..5829b9fe31650c1b5de52389320cb77d1bf4e43d 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"

diff --git a/cookbooks/postgresql/templates/default/postgresql.conf.erb b/cookbooks/postgresql/templates/default/postgresql.conf.erb
index 4bfe74fa832d8f6ce907f8f8fad18598e9678e3b..926ecef82565e267b087e1a35b611364acb2d2ac 100644 (file)
--- a/cookbooks/postgresql/templates/default/postgresql.conf.erb
+++ b/cookbooks/postgresql/templates/default/postgresql.conf.erb
@@ -43,6 +43,10 @@ work_mem = <%= @settings[:work_mem] || @defaults[:work_mem] %>
 maintenance_work_mem = <%= @settings[:maintenance_work_mem] || @defaults[:maintenance_work_mem] %>
 max_stack_depth = <%= @settings[:max_stack_depth] || @defaults[:max_stack_depth] %>
 
+# - Asynchronous Behavior -
+
+effective_io_concurrency = <%= @settings[:effective_io_concurrency] || @defaults[:effective_io_concurrency] %>
+
 #------------------------------------------------------------------------------
 # WRITE AHEAD LOG
 #------------------------------------------------------------------------------

diff --git a/roles/karm.rb b/roles/karm.rb
index d9e604a52cf0b45f47c45e8662a5e5857d52132b..e9ba46a384b00bddadeb5d35c372ca30045cbbf2 100644 (file)
--- a/roles/karm.rb
+++ b/roles/karm.rb
@@ -25,7 +25,8 @@ default_attributes(
         :shared_buffers => "64GB",
         :work_mem => "64MB",
         :maintenance_work_mem => "1GB",
-        :effective_cache_size => "180GB"
+        :effective_cache_size => "180GB",
+        :effective_io_concurrency => "256"
       }
     },
     :versions => ["9.5"]