Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Scott MarloweDate: 2008-08-26 15:29:15
Subject: Re: Large number of tables slow insert
Previous:From: Matthew WakelingDate: 2008-08-26 12:50:48
Subject: Re: Large number of tables slow insert

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group