Tune
| Setting |
Value |
<% @settings.each do |setting, value| %>
| <%= setting %> |
<%= value %> |
<% end %>
<% version_parts = @database.server_version.split(" ").first.split(".") %>
Check out <%= link_to "PgTune", "https://pgtune.leopard.in.ua/", target: "_blank" %> for recommendations. DB version is <%= version_parts[0].to_i >= 10 ? version_parts[0] : version_parts.first(2).join(".") %>.
<% if @autovacuum_settings %>
Autovacuum
| Setting |
Value |
<% @autovacuum_settings.each do |setting, value| %>
| <%= setting %> |
<%= value %>
<% if setting == :autovacuum_vacuum_cost_limit && value == "-1" %>
<%= @database.vacuum_settings[:vacuum_cost_limit] %>
<% end %>
|
<% end %>
Check out <%= link_to "Autovacuum Tuning Basics", "https://blog.2ndquadrant.com/autovacuum-tuning-basics/", target: "_blank" %> for recommendations.
<% end %>