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

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

From: Bastian Voigt <post(at)bastian-voigt(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)
Date: 2007-05-25 11:10:09
Message-ID: 4656C411.8010509@bastian-voigt.de (view raw or flat)
Thread:
Lists: pgsql-performance
Richard Huxton wrote:
>
> I was about to say that you can tune pg_autovacuum, but I just checked 
> your original post and you're running 8.0.x - not sure about that one.
The system catalog pg_autovacuum which allows finetuning autovacuum at 
table level was introduced in 8.1 :-(

> You'll have to check the documentation for that version to see if you 
> can either:
> 1. exclude that table from pg_autovacuum
> 2. increase pg_autovacuum's sensitivity
(1) seems to be impossible (correct me if I'm wrong..), so maybe I'll go 
for (2) ...

> If not, and this table is the most active, it might be simpler just to 
> run your own vacuum-ing from a cron job.
Well, it is one of the most active, but there are others. pg_autovacuum 
seems to do a very good job, apart from this one table...


-- 
Bastian Voigt
Neum├╝nstersche Stra├če 4
20251 Hamburg
telefon +49 - 40  - 67957171
mobil   +49 - 179 - 4826359



In response to

Responses

pgsql-performance by date

Next:From: Richard HuxtonDate: 2007-05-25 11:51:30
Subject: Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)
Previous:From: Richard HuxtonDate: 2007-05-25 11:00:23
Subject: Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)

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