Re: Autovacuum working / not working ?

From: Shoaib Mir <shoaibmir(at)gmail(dot)com>
To: Machiel Richards <machielr(at)rdc(dot)co(dot)za>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Autovacuum working / not working ?
Date: 2010-05-05 05:38:29
Message-ID: j2obf54be871005042238ued713f4v3b7e3cb80f18895f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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/

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Machiel Richards 2010-05-05 05:45:12 Re: Autovacuum working / not working ?
Previous Message Jaime Casanova 2010-05-05 05:37:42 Re: Autovaccum and Full vacuum