|
On Wednesday 24 December 2008 09:56:29 Scott Marlowe wrote: > On Wed, Dec 24, 2008 at 9:31 AM, Kevin Kempter > > <kevink@xxxxxxxxxxxxxxxxxxx> wrote: > > 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.. > > It's a good idea to keep an eye on system catalogs, especially if you > have a fair bit of DDL going on in your usage. I'd take a look at > what the check_postgresql.pl script does. No need to reproduce all > that work on your own. Thanks for the feedback - where can I find the check_postgresql.pl script ? |
