From: Tom Hughes Date: Wed, 10 Feb 2021 22:19:26 +0000 (+0000) Subject: Put postgres stats directory on a tmpfs X-Git-Url: https://git.openstreetmap.org/chef.git/commitdiff_plain/8fdc899e8a03bbe78abd96f150a1953846f75cd0?ds=sidebyside Put postgres stats directory on a tmpfs --- diff --git a/cookbooks/postgresql/templates/default/postgresql.conf.erb b/cookbooks/postgresql/templates/default/postgresql.conf.erb index 6b38d55d6..7ac5bb119 100644 --- a/cookbooks/postgresql/templates/default/postgresql.conf.erb +++ b/cookbooks/postgresql/templates/default/postgresql.conf.erb @@ -138,6 +138,7 @@ log_line_prefix = '%t ' # - Query/Index Statistics Collector - track_activity_query_size = <%= @settings[:track_activity_query_size] || @defaults[:track_activity_query_size] %> +stats_temp_directory = '/run/postgresql/<%= @version %>-main.pg_stat_tmp' #------------------------------------------------------------------------------ # AUTOVACUUM PARAMETERS