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 10:48:17
Message-ID: 4656BEF1.4050609@bastian-voigt.de (view raw or flat)
Thread:
Lists: pgsql-performance

OK, I'll give that a try. What about pg_autovacuum then? Is it a problem
when two processes try to vacuum the same table in parallel? Or do I
need to deactivate autovacuum altogether?
>
> Try vacuuming every 3 minutes and see what happens.
>

(Sorry Richard, forgot to reply to the list!)
-- 
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:00:23
Subject: Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)
Previous:From: Richard HuxtonDate: 2007-05-25 10:33:02
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