Skip site navigation (1) Skip section navigation (2)

Re: vacuum monitoring question

From: Kevin Kempter <kevink(at)consistentstate(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: vacuum monitoring question
Date: 2008-12-24 19:09:40
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Wednesday 24 December 2008 09:56:29 Scott Marlowe wrote:
> 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 script does.  No need to reproduce all
> that work on your own.

Thanks for the feedback - where can I find the script ?

In response to


pgsql-admin by date

Next:From: Scott MarloweDate: 2008-12-24 22:49:45
Subject: Re: vacuum monitoring question
Previous:From: Scott MarloweDate: 2008-12-24 16:56:29
Subject: Re: vacuum monitoring question

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group