lib/pghero/methods/maintenance.rb in pghero-2.0.4 vs lib/pghero/methods/maintenance.rb in pghero-2.0.5
- old
+ new
@@ -22,10 +22,10 @@
pg_class t ON c.reltoastrelid = t.oid
WHERE
c.relkind = 'r'
AND (#{quote(max_value)} - GREATEST(AGE(c.relfrozenxid), AGE(t.relfrozenxid))) < #{quote(threshold)}
ORDER BY
- 2, 1
+ 3, 1, 2
SQL
end
def autovacuum_danger
max_value = select_one("SHOW autovacuum_freeze_max_age").to_i