Hey, >> # 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? My bad - I messed up the above. I grepped for autovacuum in my process logs and included all matches. There is only one autovacuum process when it starts up. Below is the correct output from one of the logs postgres 8951 0.0 0.1 2270284 60484 pts/0 S Jun29 0:36 /usr/local/postgres/pgsql-8.2.3/bin/postgres -D /usr/local/postgres/current/data -i postgres 8989 4.9 0.0 57496 948 ? Ss Jun29 282:33 \_ postgres: logger process postgres 9002 0.0 6.4 2271532 2126852 ? Ss Jun29 2:13 \_ postgres: writer process postgres 9003 0.0 0.0 58564 1024 ? Ss Jun29 0:01 \_ postgres: archiver process postgres 9004 0.0 0.0 58448 832 ? Ss Jun29 0:00 \_ postgres: stats collector process postgres 871 0.0 0.1 2274216 36200 ? Ss Jul02 0:00 \_ postgres: postgres dbname [local] idle postgres 16508 9.2 0.1 2310836 37984 ? Ds 09:58 0:09 \_ postgres: autovacuum process dbname Thanks Dushyanth
