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