Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 3BCBB6382A3 for ; Tue, 20 Jul 2010 17:19:00 -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 99062-02 for ; Tue, 20 Jul 2010 20:18:52 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ns3a.twi.com.br (ns3a.twi.com.br [201.87.225.53]) by mail.postgresql.org (Postfix) with ESMTP id A183263768B for ; Tue, 20 Jul 2010 17:18:52 -0300 (ADT) Received: (qmail 88760 invoked from network); 20 Jul 2010 17:18:48 -0300 Received: from unknown (HELO gibon) (gibon@comexsystem.com.br@[187.36.54.37]) (envelope-sender ) by ns3a.twi.com.br (qmail-ldap-1.03) with SMTP for ; 20 Jul 2010 17:18:47 -0300 Message-ID: <007201cb2848$c21c6bf0$6500a8c0@gibon> Reply-To: =?iso-8859-1?Q?F=E1bio_Gibon_-_Comex_System?= From: =?iso-8859-1?Q?F=E1bio_Gibon_-_Comex_System?= To: "PostgreSQL - mailing list" Subject: Fw: Autovacuum on defined interval Date: Tue, 20 Jul 2010 17:18:44 -0300 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 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/150 X-Sequence-Number: 35169 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) ? 2 - what moment autovacuum check se necessary run or not? (when ocurred dml statament ?) 3 - on autovacuum is executed vacuum with FULL option or not? 4 - if autovacuum is running and i do a reload config setting autovacuum off this process will be down? thanks again... Fábio Gibon > ----- Original Message ----- > From: "Alvaro Herrera" > To: "Fábio Gibon - Comex System" > Sent: Tuesday, July 20, 2010 4:55 PM > Subject: Re: [ADMIN] Autovacuum on defined interval > > >> Excerpts from Fábio Gibon - Comex System's message of mar jul 20 >> 15:18:06 -0400 2010: >>> thanks for your reply... but i can't shutdown database (24/7) >> >> I didn't say shutdown. A reload does not kill existing connections. >> >