Re: [Postgresql 8.2.3] autovacuum starting up even after

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 sup****t

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general