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
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 |