Autovacuum does not stay turned off - Mailing list pgsql-performance

From Jerry Champlin
Subject Autovacuum does not stay turned off
Date
Msg-id 48B420F4.5020406@absolute-performance.com
Whole thread Raw
Responses Re: Autovacuum does not stay turned off
Re: Autovacuum does not stay turned off
List pgsql-performance
We are attempting to turn off autovacuum but it keeps coming back.  We
can't afford the performance hit from vacuum while end users are
accessing our system.

Postgresql Version:  8.3.3
OS:  Linux 2.6.18-53.el5PAE #1 SMP

Running PostgreSQL setting:
sspg=# show autovacuum;
 autovacuum
------------
 off
(1 row)

pg.log Log Entries:
2008-08-26 15:24:50 GMTLOG:  autovacuum launcher started
-- and then we manually kill it
postgres 32371  0.0  0.1 1133768 23572 ?       Ss   15:16   0:00
postgres: autovacuum worker process   rollup_data_store
# kill 32371
2008-08-26 15:24:53 GMTFATAL:  terminating autovacuum process due to
administrator command

Does anyone know what will cause this bahavior for autovacuum?

Thank you in advance

-Jerry


pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Large number of tables slow insert
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Autovacuum does not stay turned off