From: Jerry Champlin <jchamplin@absolute-performance.com>
To: pgsql-performance@postgresql.org
Subject: Autovacuum does not stay turned off
Date: Tue, 26 Aug 2008 09:27:48 -0600
Message-ID: <48B420F4.5020406@absolute-performance.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jchamplin@absolute-performance.com
Subject: Re: Autovacuum does not stay turned off
In-Reply-To: <48B420F4.5020406@absolute-performance.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox