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

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

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