Hey all, Iam using PostgreSQL 8.2.3 on RHEL4 (Linux 2.6.20.3-custom #4 SMP x86_64 x86_64 x86_64 GNU/Linux). I have autovacuum tunrned off in the config, but it still seems to start up once everyday. What could be the cause of this ? TIA Dushyanth $ psql -U postgres postgres=# show autovacuum; autovacuum ------------ off (1 row) $ grep autovacuum postgresql.conf #autovacuum = off #autovacuum_naptime = 60 #autovacuum_vacuum_threshold = 1000 #autovacuum_analyze_threshold = 500 #autovacuum_vacuum_scale_factor = 0.4 #autovacuum_analyze_scale_factor = 0.2 #autovacuum_vacuum_cost_delay = -1 #autovacuum_vacuum_cost_limit = -1 # autovacuum processes postgres 16508 9.2 0.1 2310836 37984 ? Ds 09:58 0:09 \_ postgres: autovacuum process db1 postgres 19626 7.2 0.0 2289524 27704 ? Ds 10:09 0:03 \_ postgres: autovacuum process db1 postgres 20861 7.8 0.0 2298844 31028 ? Ds 10:13 0:08 \_ postgres: autovacuum process db1 postgres 21673 6.1 0.1 2336904 33400 ? Ds 10:16 0:12 \_ postgres: autovacuum process db1 postgres 21673 6.2 0.1 2339840 57400 ? Ds 10:16 0:31 \_ postgres: autovacuum process db1 postgres 13597 11.6 0.0 2358352 29936 ? Ds 17:12 0:20 \_ postgres: autovacuum process db2 postgres 13597 8.7 0.1 2358352 39056 ? Ds 17:12 0:41 \_ postgres: autovacuum process db2 postgres 13597 7.8 0.1 2363924 45540 ? Ds 17:12 1:01 \_ postgres: autovacuum process db2
