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@gmail.com]
Sent: 05 May 2010 7:38 AM
To: Machiel Richards
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Autovacuum working / not working ?
On Wed, May 5, 2010 at 3:28 PM, Machiel Richards <machielr@rdc.co.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/