Re: Performance Problem with Vacuum of bytea table (PG 8.0.13) - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)
Date
Msg-id 20070527160831.GQ92628@nasby.net
Whole thread Raw
In response to Performance Problem with Vacuum of bytea table (PG 8.0.13)  (Bastian Voigt <post@bastian-voigt.de>)
List 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@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Attachment

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Memory allocation and Vacuum abends
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: Domains versus Check Constraints