On Wed, Dec 24, 2008 at 9:31 AM, Kevin Kempter
<kevink(at)consistentstate(dot)com> 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.

In response to

• vacuum monitoring question at 2008-12-24 16:31:53 from Kevin Kempter

Responses

• Re: vacuum monitoring question at 2008-12-24 19:09:40 from Kevin Kempter

pgsql-admin by date

Next:	From: Kevin Kempter	Date: 2008-12-24 19:09:40
	Subject: Re: vacuum monitoring question
Previous:	From: Kevin Kempter	Date: 2008-12-24 16:31:53
	Subject: vacuum monitoring question