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

From: Richard Huxton <dev(at)archonet(dot)com>
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-25 10:33:02
Message-ID: 4656BB5E.3000109@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bastian Voigt 2007-05-25 10:48:17 Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)
Previous Message Richard Huxton 2007-05-25 10:31:22 Re: general PG network slowness (possible cure) (repost)