Re: Autovacuum working / not working ?

I am connected to the default db (postgres).

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

Reason for asking is because the client have a total of about 120 databases
running at present , does this then need to be run on each database?

They for instance have one server with postgresql installed and running but
may have up to 24 databases created (one for each client).

Ps... a consolidation process still underway to consolidate to one server
and db with schemas for each client, however this will still take quite some
time to implement and in the meantime we need to monitor these databases.

From: Shoaib Mir [mailto:shoaibmir(at)gmail(dot)com]
Sent: 05 May 2010 7:38 AM
To: Machiel Richards
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Autovacuum working / not working ?

On Wed, May 5, 2010 at 3:28 PM, Machiel Richards <machielr(at)rdc(dot)co(dot)za> wrote:

Hi All

postgres-# where schemaname = 'public';

relname | last_vacuum | last_analyze | last_autovacuum | last_autoanalyze

---------+-------------+--------------+-----------------+------------------

(0 rows)

Hmmm... looks like you don't have any tables in the public schema, is that
true?

Or it might be you are connected to 'postgres' (default) DB and not the
correct one.

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