From gibon@comexsystem.com.br Tue Jul 20 16:27:46 2010 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id AB7F06367C0 for ; Tue, 20 Jul 2010 13:27:46 -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 92654-01 for ; Tue, 20 Jul 2010 16:27:39 +0000 (UTC) X-Greylist: delayed 00:06:39.778264 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 E62936367F3 for ; Tue, 20 Jul 2010 13:27:38 -0300 (ADT) Received: (qmail 68571 invoked from network); 20 Jul 2010 13:20:53 -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 13:20:53 -0300 Message-ID: <001001cb2827$85bdb8b0$6500a8c0@gibon> Reply-To: =?Windows-1252?Q?F=E1bio_Gibon_-_Comex_System?= From: =?Windows-1252?Q?F=E1bio_Gibon_-_Comex_System?= To: "PostgreSQL - mailing list" Subject: Autovacuum on defined interval Date: Tue, 20 Jul 2010 13:20:36 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000D_01CB280E.573C3D90" 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.801 tagged_above=-10 required=5 tests=BAYES_50=0.8, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201007/146 X-Sequence-Number: 35165 This is a multi-part message in MIME format. ------=_NextPart_000_000D_01CB280E.573C3D90 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi everybody, are there how define autovacuum to ON and define the period time = (for example, 00h - 06h) that it's can run? tks =20 F=E1bio Henrique Gibon Comex System Consultoria ------=_NextPart_000_000D_01CB280E.573C3D90 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
Hi everybody,
        are there how define = autovacuum=20 to ON and define the period time (for example, 00h - 06h) that it's = can=20 run?
 
tks
 
F=E1bio Henrique Gibon
Comex System=20 Consultoria
------=_NextPart_000_000D_01CB280E.573C3D90-- From jd@commandprompt.com Tue Jul 20 17:04:13 2010 Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 3E180636DF0 for ; Tue, 20 Jul 2010 14:04:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 92721-02 for ; Tue, 20 Jul 2010 17:04:05 +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 9A67E636DBA for ; Tue, 20 Jul 2010 14:04:05 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 7FD63348035; Tue, 20 Jul 2010 10:04:04 -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 2H6X846b0PfW; Tue, 20 Jul 2010 10:04:02 -0700 (PDT) Received: from [75.142.153.107] (unknown [75.142.153.107]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id 248AE348034; Tue, 20 Jul 2010 10:04:02 -0700 (PDT) Subject: Re: Autovacuum on defined interval From: "Joshua D. Drake" Reply-To: jd@commandprompt.com To: =?ISO-8859-1?Q?F=E1bio?= Gibon - Comex System Cc: PostgreSQL - mailing list In-Reply-To: <001001cb2827$85bdb8b0$6500a8c0@gibon> References: <001001cb2827$85bdb8b0$6500a8c0@gibon> Content-Type: text/plain; charset="UTF-8" Organization: Command Prompt, Inc. Date: Tue, 20 Jul 2010 10:03:49 -0700 Message-ID: <1279645429.3623.96.camel@jd-desktop.unknown.charter.com> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_40=-0.001 X-Spam-Level: X-Archive-Number: 201007/147 X-Sequence-Number: 35166 On Tue, 2010-07-20 at 13:20 -0300, Fábio Gibon - Comex System wrote: > Hi everybody, > are there how define autovacuum to ON and define the period > time (for example, 00h - 06h) that it's can run? > No. You would need to write your own job manager (or use one of the many that already exist) and vacuum via it. JD > tks > > Fábio Henrique Gibon > Comex System Consultoria -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering From alvherre@commandprompt.com Tue Jul 20 19:10:49 2010 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 15DE5638228 for ; Tue, 20 Jul 2010 16:10:49 -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 70025-04 for ; Tue, 20 Jul 2010 19:10:41 +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 0186E63821F for ; Tue, 20 Jul 2010 16:10:41 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 6AB98348036; Tue, 20 Jul 2010 12:10:40 -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 Zn7LkDl1bOvI; Tue, 20 Jul 2010 12:10:37 -0700 (PDT) Received: from alvh.no-ip.org (200-42-166-153.static.tie.cl [200.42.166.153]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id 429B6348034; Tue, 20 Jul 2010 12:10:37 -0700 (PDT) Received: by alvh.no-ip.org (Postfix, from userid 1000) id 7E17143820A; Tue, 20 Jul 2010 15:10:34 -0400 (CLT) Content-Type: text/plain; charset=utf8 Cc: PostgreSQL - mailing list Subject: Re: Autovacuum on defined interval From: Alvaro Herrera To: =?utf-8?q?F=C3=A1bio_Gibon_-_Comex_System?= In-reply-to: <001001cb2827$85bdb8b0$6500a8c0@gibon> References: <001001cb2827$85bdb8b0$6500a8c0@gibon> Date: Tue, 20 Jul 2010 15:10:34 -0400 Message-Id: <1279652976-sup-9283@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/149 X-Sequence-Number: 35168 Excerpts from Fábio Gibon - Comex System's message of mar jul 20 12:20:36 -0400 2010: > Hi everybody, > are there how define autovacuum to ON and define the period time (for example, 00h - 06h) that it's can run? You could have a script that toggles the value in postgresql.conf and do a Postgres reload, and run that script in cron. From gibon@comexsystem.com.br Tue Jul 20 20:19:00 2010 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. >> > From alvherre@commandprompt.com Tue Jul 20 20:53:03 2010 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.