Postgres Pro
Downloads
Home   >   mailing lists

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

From Shoaib Mir
Subject Re: Autovacuum working / not working ?
Date
Msg-id j2obf54be871005042238ued713f4v3b7e3cb80f18895f@mail.gmail.com
Whole thread Raw
In response to Autovacuum working / not working ?  ("Machiel Richards" <machielr@rdc.co.za>)
Responses Re: Autovacuum working / not working ?  ("Machiel Richards" <machielr@rdc.co.za>)
List pgsql-novice
Tree view
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/

pgsql-novice by date:

Previous
From: "Machiel Richards"
Date:
Subject: Autovacuum working / not working ?
Next
From: "Machiel Richards"
Date:
Subject: Re: Autovacuum working / not working ?