[Postgresql 8.2.3] autovacuum starting up even after disabling ? - Mailing list pgsql-general

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