Re: Autovacuum working / not working ? - Mailing list pgsql-novice

From Shoaib Mir
Subject Re: Autovacuum working / not working ?
Date
Msg-id u2mbf54be871005042251t87d05757y99c6b942faa7178b@mail.gmail.com
Whole thread Raw
In response to Re: Autovacuum working / not working ?  ("Machiel Richards" <machielr@rdc.co.za>)
List pgsql-novice
On Wed, May 5, 2010 at 3:45 PM, Machiel Richards <machielr@rdc.co.za> wrote:

I am connected to the default db (postgres).

 

Does this need to be run on a per database basis?

 


AFAIK, it has to be database specific. 

But again that shouldn't be hard as you can get a list from pg_database and loop through that using this query and pass the results to something like Nagios (or any other monitoring tool you are using) for alerts. 

--
Shoaib Mir
http://shoaibmir.wordpress.com/

pgsql-novice by date:

Previous
From: "Machiel Richards"
Date:
Subject: Re: Autovacuum working / not working ?
Next
From: Atif Jung
Date:
Subject: FETCHING into a struct in C