Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 19D65650256 for ; Fri, 31 Oct 2008 12:16:55 -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 65431-02 for ; Fri, 31 Oct 2008 12:16:52 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nrccenexf1.nrc.ca (nrccenexf1.nrc.ca [132.246.15.80]) by postgresql.org (Postfix) with ESMTP id 1FBB165026D for ; Fri, 31 Oct 2008 12:16:51 -0300 (ADT) Received: from nrccenexf1.nrc.ca ([132.246.15.80]) by nrccenexf1.nrc.ca with Microsoft SMTPSVC(6.0.3790.3959); Fri, 31 Oct 2008 11:16:50 -0400 Received: from [192.168.11.203] ([132.246.15.66]) by nrccenexf1.nrc.ca over TLS secured channel with Microsoft SMTPSVC(6.0.3790.3959); Fri, 31 Oct 2008 11:16:50 -0400 Message-ID: <490B2161.1070502@nrc-cnrc.gc.ca> Date: Fri, 31 Oct 2008 08:16:49 -0700 From: Isabella Ghiurea Reply-To: isabella.ghiurea@nrc-cnrc.gc.ca Organization: CADC -NRC User-Agent: Thunderbird 1.5.0.12 (X11/20070530) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: autovacuum questions Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 31 Oct 2008 15:16:50.0186 (UTC) FILETIME=[B2AAFEA0:01C93B6B] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200810/194 X-Sequence-Number: 30650 Hello Gurus, I'm new to PG , running PG 8.3 on Linux and reading trough docs is mentioned that in PG vers 8.3 an AUTO vacuum process has been implemented which will run full vacuum on all user and system tables + analyze and there is NO need fro DBA to schedule a crontab job to run this maintenance jobs . If this is true , here are my questions : Would like to know from your experience is this automated process sufficient and reliable in a warehouse database , can I rely only on this internal process ? How can I see when the job has been run or completed by PG ? I have configure track_count=true, what values should I go for autovacuum_naptime from your experience? Isabella