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 [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgpmVh9hXWqRK.pgp
Description: PGP signature
