From: Richard Huxton <dev@archonet.com>
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: Fri, 25 May 2007 11:33:02 +0100
Message-ID: <4656BB5E.3000109@archonet.com> (raw)
In-Reply-To: <46569E6A.2060509@bastian-voigt.de>
References: <46569E6A.2060509@bastian-voigt.de>
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.
Try vacuuming every 3 minutes and see what happens.
--
Richard Huxton
Archonet Ltd
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: dev@archonet.com, post@bastian-voigt.de
Subject: Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)
In-Reply-To: <4656BB5E.3000109@archonet.com>
* 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