From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jonah H. Harris <jonah.harris@gmail.com>
Cc: Campbell, Lance <lance@uiuc.edu>
Cc: posgres support <pgsql-admin@postgresql.org>
Subject: Re: Enhancement request
Date: Fri, 30 Nov 2007 19:34:02 -0300
Message-ID: <20071130223402.GG3175@alvh.no-ip.org> (raw)
In-Reply-To: <20071130140005.18521c54@jd-laptop>
References: <B10E6810AC2A2F4EA7550D072CDE8760197E2C@SAB-FENWICK.sab.uiuc.edu>
<36e682920711301218m703b3c67s6f547fd7b9b60e7c@mail.gmail.com>
<7099.1196458205@sss.pgh.pa.us>
<36e682920711301332q1cce5db9qe44fb068fcd5608d@mail.gmail.com>
<7341.1196459304@sss.pgh.pa.us>
<20071130140005.18521c54@jd-laptop>
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@alvh.no-ip.org, jd@commandprompt.com, tgl@sss.pgh.pa.us, jonah.harris@gmail.com, lance@uiuc.edu
Subject: Re: Enhancement request
In-Reply-To: <20071130223402.GG3175@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox