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
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 |