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

Поиск
Список
Период
Сортировка
От Wei Shan
Тема Auto Vacuum Daemon not running even though it's been configured
Дата
Msg-id CAFe9ZTo0X3e=0dm4+wJXaMbRZbBmOvfCq8bJucvXZh0n14akbw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Auto Vacuum Daemon not running even though it's been configured  ("Joshua D. Drake" <jd@commandprompt.com>)
Список 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@tiffany1 ~]# grep autovacuum /var/log/messages

Step 2:
[root@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

В списке pgsql-admin по дате отправления:

Предыдущее
От: rabi maibam
Дата:
Сообщение: more is not recognized as an internal or external command, operable program or batch file in psql in windows 7
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Auto Vacuum Daemon not running even though it's been configured