Allow cpu_tuple_cost to be configured for postgres

diff --git a/cookbooks/postgresql/attributes/default.rb b/cookbooks/postgresql/attributes/default.rb
index 1bfdb836a1a4fe288928d41225ca6fc426808f1c..bb6b0fd88c75d3f0e5f47fd3fc5eb00fcc7582bb 100644 (file)
--- a/cookbooks/postgresql/attributes/default.rb
+++ b/cookbooks/postgresql/attributes/default.rb
@@ -21,6 +21,7 @@ default[:postgresql][:settings][:defaults][:max_wal_senders] = "0"
 default[:postgresql][:settings][:defaults][:hot_standby] = "off"
 default[:postgresql][:settings][:defaults][:hot_standby_feedback] = "off"
 default[:postgresql][:settings][:defaults][:random_page_cost] = "4.0"
 default[:postgresql][:settings][:defaults][:hot_standby] = "off"
 default[:postgresql][:settings][:defaults][:hot_standby_feedback] = "off"
 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][:autovacuum_max_workers] = "3"
 default[:postgresql][:settings][:defaults][:effective_cache_size] = "128MB"
 default[:postgresql][:settings][:defaults][:log_min_duration_statement] = "-1"
 default[:postgresql][:settings][:defaults][:autovacuum_max_workers] = "3"

diff --git a/cookbooks/postgresql/templates/default/postgresql.conf.erb b/cookbooks/postgresql/templates/default/postgresql.conf.erb
index 01b796862cd1d7f208d2c3f923e2f317d70de201..42e6f88769f624c9b05b126a861f5fa3bf5537e7 100644 (file)
--- a/cookbooks/postgresql/templates/default/postgresql.conf.erb
+++ b/cookbooks/postgresql/templates/default/postgresql.conf.erb
@@ -85,6 +85,7 @@ hot_standby_feedback = <%= @settings[:hot_standby_feedback] || @defaults[:hot_st
 # - Planner Cost Constants -
 
 random_page_cost = <%= @settings[:random_page_cost] || @defaults[:random_page_cost] %>
 # - Planner Cost Constants -
 
 random_page_cost = <%= @settings[:random_page_cost] || @defaults[:random_page_cost] %>

+cpu_tuple_cost = <%= @settings[:cpu_tuple_cost] || @defaults[:cpu_tuple_cost] %>

 effective_cache_size = <%= @settings[:effective_cache_size] || @defaults[:effective_cache_size] %>
 
 #------------------------------------------------------------------------------
 effective_cache_size = <%= @settings[:effective_cache_size] || @defaults[:effective_cache_size] %>
 
 #------------------------------------------------------------------------------