Re: [GENERAL] Dumb question - how to tell if autovacuum is doing its job in 8.2.x

[Pavan Deolasee]

On 2/13/07, Walter Vaughan <[EMAIL PROTECTED]> wrote:

select last_autovacuum, last_autoanalyze from pg_stat_all_tables;
  last_autovacuum | last_autoanalyze
-----------------+------------------
                  |
...snip lots of identically blank lines...
                  |
                  |
(939 rows)

Does that mean it's working or not configured right?

It means auto vacuum/analyze did not trigger on any of the
tables. You may want to try:

SELECT name, setting from pg_settings where name like  '%autovacuum%';

to get the settings of autovacuum and check if autovacuum is turned on or
not.

Thanks,
Pavan

--

EnterpriseDB     http://www.enterprisedb.com