From 8fdc899e8a03bbe78abd96f150a1953846f75cd0 Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Wed, 10 Feb 2021 22:19:26 +0000 Subject: [PATCH] Put postgres stats directory on a tmpfs --- cookbooks/postgresql/templates/default/postgresql.conf.erb | 1 + 1 file changed, 1 insertion(+) 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 -- 2.39.5