[ADMIN] vacuum monitoring question

2008-12-24 Thread Kevin Kempter
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

Re: [ADMIN] vacuum monitoring question

2008-12-24 Thread Scott Marlowe
On Wed, Dec 24, 2008 at 9:31 AM, Kevin Kempter kev...@consistentstate.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

Re: [ADMIN] vacuum monitoring question

2008-12-24 Thread Kevin Kempter
On Wednesday 24 December 2008 09:56:29 Scott Marlowe wrote: On Wed, Dec 24, 2008 at 9:31 AM, Kevin Kempter kev...@consistentstate.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

Re: [ADMIN] vacuum monitoring question

2008-12-24 Thread Scott Marlowe
On Wed, Dec 24, 2008 at 12:09 PM, Kevin Kempter kev...@consistentstate.com wrote: Thanks for the feedback - where can I find the check_postgresql.pl script ? http://bucardo.org/check_postgres/ -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your