Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 88E602E0190
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Sat,  1 Dec 2007 16:30:41 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 29625-09 for <pgsql-admin-postgresql.org@postgresql.org>;
	Sat,  1 Dec 2007 16:30:26 -0400 (AST)
Received: from lists.commandprompt.com (host-159.commandprompt.net
	[207.173.203.159])
	by postgresql.org (Postfix) with ESMTP id A4C342E01BB
	for <pgsql-admin@postgresql.org>; Sat,  1 Dec 2007 16:30:38 -0400 (AST)
Received: from jd-laptop (cmdalert.com [69.55.229.115]) (authenticated bits=0)
	by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id lB1KUTqE023592
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Sat, 1 Dec 2007 12:30:30 -0800
Date: Sat, 1 Dec 2007 12:30:29 -0800
From: "Joshua D. Drake" <jd@commandprompt.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, "Jonah H. Harris" <jonah.harris@gmail.com>,
	"Campbell, Lance" <lance@uiuc.edu>, posgres
	support <pgsql-admin@postgresql.org>
Subject: Re: Enhancement request
Message-ID: <20071201123029.5776b3c5@jd-laptop>
In-Reply-To: <20071130223402.GG3175@alvh.no-ip.org>
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>
	<20071130223402.GG3175@alvh.no-ip.org>
Organization: Joshua D. Drake
X-Mailer: Claws Mail 3.1.0 (GTK+ 2.12.0; i486-pc-linux-gnu)
Mime-Version: 1.0
Content-Type: multipart/signed; boundary="Sig_/qzGkmTOBEr4oqpvtUYqP1v1";
	protocol="application/pgp-signature"; micalg=PGP-SHA1
X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0
	(lists.commandprompt.com [207.173.203.159]);
	Sat, 01 Dec 2007 12:30:31 -0800 (PST)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200712/1
X-Sequence-Number: 27518

--Sig_/qzGkmTOBEr4oqpvtUYqP1v1
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

On Fri, 30 Nov 2007 19:34:02 -0300
Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:

> Joshua D. Drake escribi=C3=83=C2=B3:
>=20
> > 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.
> >=20
> > 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).
>=20
> Huh, autovac will consume exactly the same amount of I/O as a
> user-induced vacuum, so I don't see your point.

It can be determined "when" the I/O is used.

> 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.
>=20

I assume you mean 8.3, but that is certainly a valid point.

Sincerely,

Joshua D. Drake

--Sig_/qzGkmTOBEr4oqpvtUYqP1v1
Content-Type: application/pgp-signature; name=signature.asc
Content-Disposition: attachment; filename=signature.asc

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHUcRlATb/zqfZUUQRAl7/AJ4oOM/u2Si0Pkcv8nyfV4lueWPv4gCfQalc
gKHB+jtjc53jMMaahz2qOZI=
=SaoU
-----END PGP SIGNATURE-----

--Sig_/qzGkmTOBEr4oqpvtUYqP1v1--