Hi All;
I'm working on a vacuum monitor script to alert us when tables start to grow
out of control per dead space. Initially I excluded the system catalog
schemas (pg_catalog, pg_toast, etc) however I wonder if maybe I should monitor
these as well. PLus I'm looking for any input as to specifically what to look
for - I've calculated a 'fill factor' which shows the average page fill as a
percentage but I wonder what other metrics may help monitor possible problem
tables effeciently..
Thoughts ?
Thanks in advance