Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 2670E9FB336; Wed, 18 Oct 2006 16:10:41 -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 55020-05; Wed, 18 Oct 2006 19:10:36 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 92F0F9FB2CC; Wed, 18 Oct 2006 16:10:36 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 3F1B156446; Wed, 18 Oct 2006 14:10:35 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Wed, 18 Oct 2006 14:10:27 -0500 Date: Wed, 18 Oct 2006 14:10:27 -0500 From: "Jim C. Nasby" To: Tobias Brox Cc: "Matthew T. O'Connor" , Csaba Nagy , Edoardo Ceccarelli , postgres performance list , pgsql-admin@postgresql.org Subject: Re: [PERFORM] autovacuum on a -mostly- r/o table Message-ID: <20061018191027.GM85041@nasby.net> References: <20061015095259.GA24002@oppetid.no> <453248DA.7050806@zeut.net> <20061015145212.GA13175@oppetid.no> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20061015145212.GA13175@oppetid.no> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:061018:tobias@nordicbet.com::NCG5wwk+4AQf6jXf:00000000000000000 00000000000000000000000007i3 X-Hashcash: 1:20:061018:matthew@zeut.net::oafHJL5Rj1Az06AR:07tVg X-Hashcash: 1:20:061018:nagy@ecircle-ag.com::JnipqyUm9cZ+gQjx:000000000000000000 000000000000000000000000BxTf X-Hashcash: 1:20:061018:eddy@axa.it::nUMIwaZg5POYlWrV:0000009lmN X-Hashcash: 1:20:061018:pgsql-performance@postgresql.org::p1XpoAR7exqDGTI3:00000 0000000000000000000000009XPo X-Hashcash: 1:20:061018:pgsql-admin@postgresql.org::3LyZCHyX90BaHr2o:00000000000 00000000000000000000000004sV 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/113 X-Sequence-Number: 23416 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. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)