Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 28A0B63EE74 for ; Tue, 20 Jul 2010 17:53:03 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 11490-02 for ; Tue, 20 Jul 2010 20:52:54 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id B720B63EE94 for ; Tue, 20 Jul 2010 17:52:55 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 04096348035; Tue, 20 Jul 2010 13:52:54 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at commandprompt.com Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ttwQL4azrHlI; Tue, 20 Jul 2010 13:52:51 -0700 (PDT) Received: from alvh.no-ip.org (unknown [186.9.203.182]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id CE611348034; Tue, 20 Jul 2010 13:52:48 -0700 (PDT) Received: by alvh.no-ip.org (Postfix, from userid 1000) id 434C643820A; Tue, 20 Jul 2010 16:52:37 -0400 (CLT) Content-Type: text/plain; charset=utf8 Cc: pgsql-admin@postgresql.org Subject: Re: Autovacuum on defined interval From: Alvaro Herrera To: =?utf-8?q?F=C3=A1bio_Gibon_-_Comex_System?= In-reply-to: <006601cb2848$1416dc70$6500a8c0@gibon> References: <001001cb2827$85bdb8b0$6500a8c0@gibon> <1279652976-sup-9283@alvh.no-ip.org> <005f01cb2840$50de3930$6500a8c0@gibon> <1279655699-sup-258@alvh.no-ip.org> <006601cb2848$1416dc70$6500a8c0@gibon> Date: Tue, 20 Jul 2010 16:52:37 -0400 Message-Id: <1279658949-sup-5628@alvh.no-ip.org> User-Agent: Sup/0.11 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201007/151 X-Sequence-Number: 35170 Excerpts from Fábio Gibon - Comex System's message of mar jul 20 16:13:39 -0400 2010: > Perfect!!! > > I'm starting with PostgreSQL (my knowledge is Oracle). Can you explain more > about autovacuum? for example... > 1 - on windows SO, autovacuum start works (postgres.exe as > autovacuum_max_workers) ? I think questions (1) and (2) are best answered in the docs: http://www.postgresql.org/docs/current/static/routine-vacuuming.html#AUTOVACUUM Please have a read and let us know if you have further questions. > 3 - on autovacuum is executed vacuum with FULL option or not? No, by design autovacuum never invokes any blocking activity. > 4 - if autovacuum is running and i do a reload config setting autovacuum off > this process will be down? The launcher will be shut down, but any worker currently processing tables will continue until finished with its tables.