pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jim C. Nasby <decibel@decibel.org>
To: Bastian Voigt <post@bastian-voigt.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)
Date: Sun, 27 May 2007 11:08:31 -0500
Message-ID: <20070527160831.GQ92628@nasby.net> (raw)
In-Reply-To: <46569E6A.2060509@bastian-voigt.de>
References: <46569E6A.2060509@bastian-voigt.de>

On Fri, May 25, 2007 at 10:29:30AM +0200, Bastian Voigt wrote:
> Hi *,
> for caching large autogenerated XML files, I have created a bytea table 
> in my database so that the cached files can be used by multiple servers. 
> There are about 500 rows and 10-20 Updates per minute on the table. The 
> files stored in the bytea are anything from 10kB to 10MB. My PostgreSQL 
> version is 8.0.13 on Gentoo Linux (x86) with PostGIS 1.2.0.
> 
> For vacuum I use the pg_autovacuum daemon. It decided to vacuum my cache 
> table about every 3 hours, the vacuum process takes 20-30 minutes 
> (oops!) every time.

You'll want to decrease autovacum_vacuum_scale_factor to 0.2 if you're
on anything less than 8.2.
-- 
Jim Nasby                                      decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

view thread (8+ messages)

Message-ID: <20070527160831.GQ92628@nasby.net>
Permalink:  ../20070527160831.GQ92628@nasby.net/
Also on:    postgresql.org/message-id/20070527160831.GQ92628@nasby.net

 · 

reply

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: decibel@decibel.org, post@bastian-voigt.de
  Subject: Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)
  In-Reply-To: <20070527160831.GQ92628@nasby.net>

* 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