Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 3D0AB6506D1
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 14 Jul 2008 17:35:41 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 94600-05 for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 14 Jul 2008 17:35:26 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from hs-out-0708.google.com (hs-out-0708.google.com
 [64.233.178.249])
	by postgresql.org (Postfix) with ESMTP id F2D8265068A
	for <pgsql-admin@postgresql.org>; Mon, 14 Jul 2008 17:35:22 -0300 (ADT)
Received: by hs-out-0708.google.com with SMTP id x43so1339119hsb.3
	for <pgsql-admin@postgresql.org>; Mon, 14 Jul 2008 13:35:15 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:cc:in-reply-to:mime-version:content-type:references;
	bh=VLZLpH1qP9Dp0LJs8KyepTRdhJRDQfReKUS0zudgCvQ=;
	b=GxXao1D2soMf5Rzn4OwujEg3BhNkGUdh6k1kvypCebYfDsLX8cWph14ChYgpkEC10d
	bx+C1Or1v9jhbUfwQLVtmTEk7lk9i5+LwlgDP2PjUS0UOAqmbhT94/CTivA0aWXHPIsd
	sF99RN+jiaKI+5J1qNTkt4A/lgDGMQdyLIOqc=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:references;
	b=K7Kodmduc/BuFD3+pEd078/lAhrSE1wTM7Sslb/gs4hlq3tlSj1+87l1jZir8CS2jH
	BWDPX/I+liMI23QeE2CDb5sP42NaCitFadfS7ce/EZ72j4gMw4ccZ1+eBNab9Sadx7Gn
	WgsVfqf6Vz/qscp+Jf8KEkIqd5IymMLlh/6Y8=
Received: by 10.100.41.8 with SMTP id o8mr10735372ano.82.1216067681860;
	Mon, 14 Jul 2008 13:34:41 -0700 (PDT)
Received: by 10.100.122.6 with HTTP; Mon, 14 Jul 2008 13:34:41 -0700 (PDT)
Message-ID: <1d219a6f0807141334s2ca9b2fu1939f6ab80310f51@mail.gmail.com>
Date: Mon, 14 Jul 2008 16:34:41 -0400
From: "Chris Hoover" <revoohc@gmail.com>
To: "Alvaro Herrera" <alvherre@commandprompt.com>
Subject: Re: 8.3 Autovacuum Questions
Cc: "pgsql-admin@postgresql.org Admin" <pgsql-admin@postgresql.org>
In-Reply-To: <20080714202933.GK4050@alvh.no-ip.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_83196_16718970.1216067681849"
References: <1d219a6f0807141326p16d86505o84642b8d49fa6ad8@mail.gmail.com>
	<20080714202933.GK4050@alvh.no-ip.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200807/128
X-Sequence-Number: 29738

------=_Part_83196_16718970.1216067681849
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Mon, Jul 14, 2008 at 4:29 PM, Alvaro Herrera <alvherre@commandprompt.com=
>
wrote:

> Chris Hoover escribi=F3:
> > I just have a couple of quick questions about 8.3 and Autovacuum.
> >
> > 1.  When autovacuum chooses to vacuum a table, the entire table is
> vacuumed,
> > and not just a specified percentage of the table.  Correct?
>
> Yes.
>
> > 2.  There is no way, without turning autovacuum off, of excluding
> > vacuum/analyze during a specific period of time (say during a known pea=
k
> > usage period).
>
> Nope, no way.  (You could have a script to update the
> pg_autovacuum.enabled flag, and change it using cron.)
>
> > 3.  If I have a PostgreSQL cluster with 10 databases, does
> > autovacuum_max_workers=3D3 mean I have a possibility of 3 total workers=
 or
> 30
> > workers (i.e. autovacuum_max_workers * number of db's)?
>
> 3 workers total.
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>

Alvaro,

Thanks a bunch for the concise answers.  That is exactly what we needed to
confirm.

Chris

------=_Part_83196_16718970.1216067681849
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<br><br><div class=3D"gmail_quote">On Mon, Jul 14, 2008 at 4:29 PM, Alvaro =
Herrera &lt;<a href=3D"mailto:alvherre@commandprompt.com">alvherre@commandp=
rompt.com</a>&gt; wrote:<br><blockquote class=3D"gmail_quote" style=3D"bord=
er-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-l=
eft: 1ex;">
Chris Hoover escribi=F3:<br>
<div class=3D"Ih2E3d">&gt; I just have a couple of quick questions about 8.=
3 and Autovacuum.<br>
&gt;<br>
&gt; 1. &nbsp;When autovacuum chooses to vacuum a table, the entire table i=
s vacuumed,<br>
&gt; and not just a specified percentage of the table. &nbsp;Correct?<br>
<br>
</div>Yes.<br>
<div class=3D"Ih2E3d"><br>
&gt; 2. &nbsp;There is no way, without turning autovacuum off, of excluding=
<br>
&gt; vacuum/analyze during a specific period of time (say during a known pe=
ak<br>
&gt; usage period).<br>
<br>
</div>Nope, no way. &nbsp;(You could have a script to update the<br>
pg_autovacuum.enabled flag, and change it using cron.)<br>
<div class=3D"Ih2E3d"><br>
&gt; 3. &nbsp;If I have a PostgreSQL cluster with 10 databases, does<br>
&gt; autovacuum_max_workers=3D3 mean I have a possibility of 3 total worker=
s or 30<br>
&gt; workers (i.e. autovacuum_max_workers * number of db&#39;s)?<br>
<br>
</div>3 workers total.<br>
<font color=3D"#888888"><br>
--<br>
Alvaro Herrera &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbs=
p; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<a href=3D"http://www.Co=
mmandPrompt.com/" target=3D"_blank">http://www.CommandPrompt.com/</a><br>
The PostgreSQL Company - Command Prompt, Inc.<br>
</font></blockquote></div><br>Alvaro,<br><br>Thanks a bunch for the concise=
 answers.&nbsp; That is exactly what we needed to confirm.<br clear=3D"all"=
><br>Chris<br>

------=_Part_83196_16718970.1216067681849--