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 = 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:
LOG:autovacuum launcher started
- check autovacuum launcher process by ps
# ps aux|grep autovacuum
root64640.00.0 103252828 pts/0R+07:520:00 grep autovacuum
postgres 277540.00.0 602780804 ?SsJul030:28 postgres: autovacuum launcher process推荐阅读
- 近期写PostgreSql的笔记
- PostgreSQL|PostgreSQL 咨询锁advisory lock使用详解
- postgresql集群报错解决（SELECT pg_catalog.pg_try_advisory_xact_lock_shared(65535, 65535)）
- SQL|SQL基础教程总结
- PostgreSQL 查找替换函数
- 中韩印尼6大子论坛齐聚 | PGConf.Asia亚洲技术大会DAY3迎来收官！
- 获取上下一个工作日实践
- postgresql|postgresql在docker中启用ssl
- 集齐五大洲嘉宾，PGConf.Asia-英文技术论坛全球直播