We increased "vacuum_cost_limit" globally and decreased "autovacuum_vacuum_scale_factor" and "autovacuum_analyze_scale_factor" for large tables. Most of them by

We increased "vacuum_cost_limit" globally and decreased "autovacuum_vacuum_scale_factor" and "autovacuum_analyze_scale_factor" for large tables. Most of them by a factor 4~5x. The docs explain the different settings: https://www.postgresql.org/docs/9.6/static/runtime-config-autovacuum.html https://www.postgresql.org/docs/9.6/static/runtime-config-au... When tweaking performance settings, always benchmark, especially with your specific load characteristics.