Auto Vacuum Daemon not running even though it's been configured

From: Wei Shan <weishan(dot)ang(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Auto Vacuum Daemon not running even though it's been configured
Date: 2015-07-22 02:16:32
Message-ID: CAFe9ZTo0X3e=0dm4+wJXaMbRZbBmOvfCq8bJucvXZh0n14akbw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

I'm running PostgreSQL 9.2.4. I have autovacuum configured within my
database. However, when I verify it, it has never been ran even though the
autovacuum process is running.

*Autovacuum Parameters:*

postgres=# show autovacuum;
autovacuum
------------
on

postgres=# show track_counts;
track_counts
--------------
on

*Verification:*

*Step 1:*
[root(at)tiffany1 ~]# grep autovacuum /var/log/messages

*Step 2:*
[root(at)tiffany1 ~]# ps -aef | grep autovacuum
postgres 4923 4883 0 Jul20 ? 00:00:15 postgres: autovacuum
launcher process
root 52995 5313 0 10:12 pts/0 00:00:00 grep autovacuum

*Step 3:*
select
schemaname,relname,last_vacuum,last_autovacuum,last_analyze,last_autoanalyze,vacuum_count,autovacuum_count,analyze_count,autoanalyze_count
from pg_stat_user_tables;

All the values were 0 for the tables in every single database.

Any advice please?

Thanks!

--
Regards,
Ang Wei Shan

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2015-07-22 02:46:26 Re: Auto Vacuum Daemon not running even though it's been configured
Previous Message rabi maibam 2015-07-21 11:27:43 more is not recognized as an internal or external command, operable program or batch file in psql in windows 7