From 2a6b1a10e8d55bf028ebd0178d13eaaa0832d893 Mon Sep 17 00:00:00 2001 From: Paul Norman Date: Fri, 16 May 2025 17:41:44 -0700 Subject: [PATCH] vectortile: Turn on pgstattuple for bloat monitoring --- cookbooks/vectortile/recipes/default.rb | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/cookbooks/vectortile/recipes/default.rb b/cookbooks/vectortile/recipes/default.rb index 77bb9da82..1c183078d 100644 --- a/cookbooks/vectortile/recipes/default.rb +++ b/cookbooks/vectortile/recipes/default.rb @@ -158,6 +158,11 @@ postgresql_database "tiles" do owner "tileupdate" end +postgresql_extension "pgstattuple" do + cluster node[:vectortile][:database][:cluster] + database "tiles" +end + postgresql_database "spirit" do cluster node[:vectortile][:database][:cluster] owner "tileupdate" -- 2.39.5