X-Git-Url: https://git.openstreetmap.org/chef.git/blobdiff_plain/b767bc1e4b784c6613ff7ad009accdcd33263309..5c2ce2d18b182ae5f860ad8dcbbc8cf4c045acf7:/cookbooks/postgresql/templates/default/postgresql.conf.erb diff --git a/cookbooks/postgresql/templates/default/postgresql.conf.erb b/cookbooks/postgresql/templates/default/postgresql.conf.erb index 754131e73..926ecef82 100644 --- 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 #------------------------------------------------------------------------------ @@ -58,10 +62,14 @@ commit_delay = <%= @settings[:commit_delay] || @defaults[:commit_delay] %> # - Checkpoints - -<% if @version.to_f < 9.5 %> +<% if @version.to_f < 9.5 -%> checkpoint_segments = <%= @settings[:checkpoint_segments] || @defaults[:checkpoint_segments] %> <% end -%> checkpoint_timeout = <%= @settings[:checkpoint_timeout] || @defaults[:checkpoint_timeout] %> +<% if @version.to_f >= 9.5 -%> +max_wal_size = <%= @settings[:max_wal_size] || @defaults[:max_wal_size] %> +min_wal_size = <%= @settings[:min_wal_size] || @defaults[:min_wal_size] %> +<% end -%> checkpoint_completion_target = <%= @settings[:checkpoint_completion_target] || @defaults[:checkpoint_completion_target] %> # - Archiving - @@ -106,6 +114,14 @@ log_min_duration_statement = <%= @settings[:log_min_duration_statement] || @defa log_line_prefix = '%t ' +#------------------------------------------------------------------------------ +# RUNTIME STATISTICS +#------------------------------------------------------------------------------ + +# - Query/Index Statistics Collector - + +track_activity_query_size = <%= @settings[:track_activity_query_size] || @defaults[:track_activity_query_size] %> + #------------------------------------------------------------------------------ # AUTOVACUUM PARAMETERS #------------------------------------------------------------------------------