From 67a74cd7644359f67bd5f80ae58fc451c6467d8a Mon Sep 17 00:00:00 2001
From: Paul Norman <penorman@mac.com>
Date: Tue, 20 Feb 2018 06:35:37 -0800
Subject: [PATCH] Set autovacuum scale factors for tile servers

Reducing these factors helps make sure autovacuum runs often
enough and keeps bloat down.

Closes #152
---
 roles/tile.rb | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/roles/tile.rb b/roles/tile.rb
index 6c7da5a01..b0f7c930e 100644
--- a/roles/tile.rb
+++ b/roles/tile.rb
@@ -43,7 +43,9 @@ default_attributes(
         :checkpoint_segments => "60",
         :max_wal_size => "2880MB",
         :random_page_cost => "1.1",
-        :track_activity_query_size => "16384"
+        :track_activity_query_size => "16384",
+        :autovacuum_vacuum_scale_factor => "0.05",
+        :autovacuum_analyze_scale_factor => "0.02"
       }
     }
   },
-- 
2.43.2