Re: [Postgresql 8.2.3] autovacuum starting up even after disabling ?

Dushyanth escribió:

> # 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

Something is seriously wrong here -- there should be only one autovacuum
process ever in 8.2. Can you show a more complete ps tree, and perhaps
include PPID in the listing?

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support