Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 654399FB34F; Wed, 27 Sep 2006 13:13:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 15276-05; Wed, 27 Sep 2006 13:13:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.ecircle.de (mail.ecircle.de [195.140.186.200]) by postgresql.org (Postfix) with ESMTP id 89E079FB342; Wed, 27 Sep 2006 13:13:45 -0300 (ADT) Received: from einstein.muc.ecircle.de (einstein.muc.ecircle.de [192.168.1.7]) by mail.ecircle.de (READY) with ESMTP id A10C455C06E; Wed, 27 Sep 2006 18:13:44 +0200 (CEST) Received: from [192.168.1.91] ([192.168.1.91]) by einstein.muc.ecircle.de with Microsoft SMTPSVC(6.0.3790.1830); Wed, 27 Sep 2006 18:14:28 +0200 Subject: Re: [PERFORM] autovacuum on a -mostly- r/o table From: Csaba Nagy To: Edoardo Ceccarelli Cc: postgres performance list , pgsql-admin@postgresql.org In-Reply-To: <451AA1FE.9050704@axa.it> References: <451AA1FE.9050704@axa.it> Content-Type: text/plain Message-Id: <1159373624.3874.187.camel@coppola.muc.ecircle.de> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Wed, 27 Sep 2006 18:13:44 +0200 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 27 Sep 2006 16:14:29.0191 (UTC) FILETIME=[02628570:01C6E250] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.203 tagged_above=0 required=5 tests=AWL, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/327 X-Sequence-Number: 23241 On Wed, 2006-09-27 at 18:08, Edoardo Ceccarelli wrote: > How can I configure the vacuum to run after the daily batch insert/update? Check out this: http://www.postgresql.org/docs/8.1/static/catalog-pg-autovacuum.html By inserting the right row you can disable autovacuum to vacuum your big tables, and then you can schedule vacuum nightly for those just as before. There's still a benefit in that you don't need to care about vacuuming the rest of the tables, which will be done just in time. Cheers, Csaba.