How do I know whether autovacuum is enabled in PostgreSQL?

转载于 2019-06-28 00:09:13 发布 · 265 阅读

文章标签：

#autovacuum #PostgreSQL

PostgreSQL 专栏收录该内容

211 篇文章

订阅专栏

本文解释了如何确定PostgreSQL数据库中的自动清理(autovacuum)功能是否启用。默认情况下，autovacuum处于开启状态。要验证这一点，可以在启动日志中查找特定消息，或者通过检查系统进程中是否存在autovacuum进程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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:

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+   07:52   0:00 grep autovacuum
postgres 27754  0.0  0.0 602780   804 ?        Ss   Jul03   0:28 postgres: autovacuum launcher process