Autovacuum does not stay turned off

From: Jerry Champlin <jchamplin(at)absolute-performance(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Autovacuum does not stay turned off
Date: 2008-08-26 15:27:48
Message-ID: 48B420F4.5020406@absolute-performance.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-08-26 15:29:15 Re: Large number of tables slow insert
Previous Message Matthew Wakeling 2008-08-26 12:50:48 Re: Large number of tables slow insert