Re: [PERFORM] autovacuum on a -mostly- r/o table - Mailing list pgsql-admin

From Rod Taylor
Subject Re: [PERFORM] autovacuum on a -mostly- r/o table
Date
Msg-id 1159374712.46586.47.camel@home
Whole thread Raw
In response to autovacuum on a -mostly- r/o table  (Edoardo Ceccarelli <eddy@axa.it>)
List pgsql-admin
On Wed, 2006-09-27 at 18:08 +0200, Edoardo Ceccarelli wrote:
>
> I have read that autovacuum cannot check to see pg load before
> launching
> vacuum but is there any patch about it? that would sort out the
> problem
> in a good and simple way.

In some cases the solution to high load is to vacuum the tables being
hit the heaviest -- meaning that simply checking machine load isn't
enough to make that decision.

In fact, that high load problem is exactly why autovacuum was created in
the first place.
--


pgsql-admin by date:

Previous
From: "Trefethen, Zachary J"
Date:
Subject: having trouble restoring a database from files
Next
From: Andrea Gozzi
Date:
Subject: Re: having trouble restoring a database from files