Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [PERFORM] autovacuum on a -mostly- r/o table
- From: Rod Taylor <pg(at)rbt(dot)ca>
- To: Edoardo Ceccarelli <eddy(at)axa(dot)it>
- Cc: pgsql-performance(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
- Subject: Re: [PERFORM] autovacuum on a -mostly- r/o table
- Date: Wed, 27 Sep 2006 12:31:52 -0400
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. --
- References:
- autovacuum on a -mostly- r/o table
- From: Edoardo Ceccarelli
- autovacuum on a -mostly- r/o table
- Prev by Date: having trouble restoring a database from files
- Next by Date: Re: having trouble restoring a database from files
- Previous by thread: Re: [PERFORM] autovacuum on a -mostly- r/o table
- Next by thread: having trouble restoring a database from files
- Indexes: