Set autovacuum scale factors for tile servers
authorPaul Norman <penorman@mac.com>
Tue, 20 Feb 2018 14:35:37 +0000 (06:35 -0800)
committerTom Hughes <tom@compton.nu>
Tue, 20 Feb 2018 16:09:46 +0000 (16:09 +0000)
Reducing these factors helps make sure autovacuum runs often
enough and keeps bloat down.

Closes #152

roles/tile.rb

index 6c7da5a..b0f7c93 100644 (file)
@@ -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"
       }
     }
   },