Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5DF266506A8 for ; Mon, 14 Jul 2008 17:26:17 -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 85482-08 for ; Mon, 14 Jul 2008 17:26:08 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.230]) by postgresql.org (Postfix) with ESMTP id 27B4765068A for ; Mon, 14 Jul 2008 17:26:11 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id c49so3901661wra.19 for ; Mon, 14 Jul 2008 13:26:10 -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:mime-version:content-type; bh=e8XpPpaY59Y1nyjxwGTQ8lGDjfW5zf8mmSfcXEIl2Qg=; b=XSSHeMU5ud3m5se+OH7PoPu8GyGXH22sEJQjA/JU2RLSVc04vafdJy7aIbxBhj4JwO gDYCr/ReB10ZCe9OXvu8nMef3L21jJguDwLOUQnPzii7kbZYwrVzQ8D1aQRWcL7mkUEg cfxxuB3isjrY9T2OQJs2iSowVi3pgdFSLtRJs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=ZwCYkfeawqlmLOWgwtzhgW3V/7OMFDaFcAvifKM4+AJAQ+fIcrveYtvEqWBU1hmTRy 6dyEAIo8cNjalANUi2XOAu3ukHLB9Jp1d8rtq5+naJuiFIh76VBpOC5JZ4WGIVof3DFO uupQhG/cBrg5aVGmwH+ASc9iF/tjq/qAAzsxU= Received: by 10.100.140.12 with SMTP id n12mr10716304and.61.1216067168979; Mon, 14 Jul 2008 13:26:08 -0700 (PDT) Received: by 10.100.122.6 with HTTP; Mon, 14 Jul 2008 13:26:08 -0700 (PDT) Message-ID: <1d219a6f0807141326p16d86505o84642b8d49fa6ad8@mail.gmail.com> Date: Mon, 14 Jul 2008 16:26:08 -0400 From: "Chris Hoover" To: "pgsql-admin@postgresql.org Admin" Subject: 8.3 Autovacuum Questions MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_83022_4994698.1216067168931" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/126 X-Sequence-Number: 29736 ------=_Part_83022_4994698.1216067168931 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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? 2. There is no way, without turning autovacuum off, of excluding vacuum/analyze during a specific period of time (say during a known peak usage period). 3. If I have a PostgreSQL cluster with 10 databases, does autovacuum_max_workers=3 mean I have a possibility of 3 total workers or 30 workers (i.e. autovacuum_max_workers * number of db's)? Thanks, Chris ------=_Part_83022_4994698.1216067168931 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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?

2.  There is no way, without turning autovacuum off, of excluding vacuum/analyze during a specific period of time (say during a known peak usage period).

3.  If I have a PostgreSQL cluster with 10 databases, does autovacuum_max_workers=3 mean I have a possibility of 3 total workers or 30 workers (i.e. autovacuum_max_workers * number of db's)?

Thanks,

Chris
------=_Part_83022_4994698.1216067168931--