Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id CF1689FB1E6; Wed, 18 Oct 2006 17:59:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 81738-09; Wed, 18 Oct 2006 20:59:48 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 1A2EB9F9CD0; Wed, 18 Oct 2006 17:59:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from thebighonker.lerctr.org (thebighonker.lerctr.org [192.147.25.65]) by svr4.postgresql.org (Postfix) with ESMTP id 0F6E65AF8C8; Wed, 18 Oct 2006 20:59:44 +0000 (GMT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=lerami; d=lerctr.org; h=Received:From:To:Cc:Subject:Date:Message-ID:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Mailer:In-Reply-To:thread-index:X-MimeOLE:X-Spam-Score:X-LERCTR-Spam-Score:X-Spam-Report:X-LERCTR-Spam-Report:DomainKey-Status; b=wI/NnvFxKlSr6hTChS6SsX9+DuIBWaA/4mjB3T+G9ebBdBViAwUV/nimvikntHOhS3UJcG38EVuiR7eGOSfOQPQRdX+Bo1jz9Y5u9iSSx2o+SWcqYePDM96qe7Yx+22+YP664n8gVNZ+aAPxthLK5+BtP4B3lXkbInzXwDDgnIw=; Received: from [66.179.40.122] (port=12763 helo=SURGLROSENMAN) by thebighonker.lerctr.org with esmtpa (Exim 4.63 (FreeBSD)) (envelope-from ) id 1GaIVg-0007gI-Bj; Wed, 18 Oct 2006 15:59:34 -0500 From: "Larry Rosenman" To: "'Jim C. Nasby'" , "'Tobias Brox'" Cc: "'Matthew T. O'Connor'" , "'Csaba Nagy'" , "'Edoardo Ceccarelli'" , "'postgres performance list'" , Subject: Re: [PERFORM] autovacuum on a -mostly- r/o table Date: Wed, 18 Oct 2006 15:59:22 -0500 Message-ID: <034b01c6f2f8$4f875c00$0202fea9@SURGIENT.COM> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 In-Reply-To: <20061018191027.GM85041@nasby.net> thread-index: Acby6TIwEDDL/vLHQOCnfy+1+qUo/wADwW5g X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-LERCTR-Spam-Score: -4.4 (----) X-LERCTR-Spam-Report: (-4.4 points, 5.0 required) ALL_TRUSTED=-1.8 BAYES_00=-2.599 DomainKey-Status: no signature X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/114 X-Sequence-Number: 23417 Jim C. Nasby wrote: > On Sun, Oct 15, 2006 at 04:52:12PM +0200, Tobias Brox wrote: >> Are there any logs that can help me, and eventually, are there any >> ready-made scripts for checking when autovacuum is running, and >> eventually for how long it keeps its transactions? I'll probably >> write up something myself if not. > > 8.2 adds some stats on when autovac last ran, per-table. I don't > remember if it reports how long it took to vacuum the table, but that > would probably be useful info. It does NOT. It's just the timestamp of the END of the vacuum / analyze. (I'm the author of the patch). -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893