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

Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: Bastian Voigt <post(at)bastian-voigt(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)
Date: 2007-05-27 16:08:31
Message-ID: 20070527160831.GQ92628@nasby.net (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)decibel(dot)org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

In response to

pgsql-performance by date

Next:From: Stefan KaltenbrunnerDate: 2007-05-27 16:34:22
Subject: Re: Domains versus Check Constraints
Previous:From: Jim C. NasbyDate: 2007-05-27 16:06:48
Subject: Re: Memory allocation and Vacuum abends

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