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

Re: Enhancement request

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, "Campbell, Lance" <lance(at)uiuc(dot)edu>, posgres support <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Enhancement request
Date: 2007-11-30 22:34:02
Message-ID: 20071130223402.GG3175@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-admin
Joshua D. Drake escribió:

> Autovacuum is a great utility for many workloads but even with the
> upcoming changes I will continually find myself turning off autovacuum
> for specific relations just so I can turn around and turn on vacuum
> within cron for others.
> 
> The multi-worker autovacuum is a great new addition to help part of
> that problem (starvation) but it is not help against the other
> (resource consumption, specifically IO).

Huh, autovac will consume exactly the same amount of I/O as a
user-induced vacuum, so I don't see your point.

Multiworker autovac hasn't been tried on your customer's servers yet.
It may well turn out to be that it is possible to let it do its work
even on the high-update tables or large tables that you currently use
cron for.  It might be just a matter of tuning the knobs.

Remember, we're not adding VACUUM SCHEMA in 8.2 so it doesn't make any
sense to try to compare it against the old autovac.  And you can bet
that in 8.4 autovac will have even more goodies.

-- 
Alvaro Herrera       Valdivia, Chile   ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
"This is a foot just waiting to be shot"                (Andrew Dunstan)

In response to

Responses

pgsql-admin by date

Next:From: Jonah H. HarrisDate: 2007-11-30 22:53:01
Subject: Re: Enhancement request
Previous:From: Chris BrowneDate: 2007-11-30 22:23:25
Subject: Re: Enhancement request

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