HowdoIknowwhetherautovacuumisenabledinPostgreSQL?

https://access.redhat.com/solutions/506533

 SOLUTION IN PROGRESS - 已更新 2014年七月10日15:10 - 

English 

环境

• Red Hat Enterprise Linux 6
• postgresql

问题

• How do I know whether autovacuum is enabled?
• "autovacuum &＃61; on" is commented out in the postgresql.conf. What is the default value, on or off?

决议

• autovacuum is on by default. To confirm, look for the following output in pg_log/postgresql-.log during startup:

Raw

LOG: autovacuum launcher started


• check autovacuum launcher process by ps

Raw

# ps aux|grep autovacuum
root 6464 0.0 0.0 103252 828 pts/0 R&＃43; 07:52 0:00 grep autovacuum
postgres 27754 0.0 0.0 602780 804 ? Ss Jul03 0:28 postgres: autovacuum launcher process