Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id BAD829FB2FD for ; Tue, 10 Oct 2006 15:44:09 -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 61249-06 for ; Tue, 10 Oct 2006 15:43:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from lynet.oppetid.no (oppetid.no [80.65.51.2]) by postgresql.org (Postfix) with ESMTP id C558E9FB25A for ; Tue, 10 Oct 2006 15:43:55 -0300 (ADT) Received: by lynet.oppetid.no (Postfix, from userid 1019) id D3AB8119EF0; Tue, 10 Oct 2006 20:43:54 +0200 (CEST) Date: Tue, 10 Oct 2006 20:43:54 +0200 From: Tobias Brox To: Tom Lane Cc: Tobias Brox , pgsql-performance@postgresql.org Subject: Re: long running transactions Message-ID: <20061010184354.GA24098@oppetid.no> References: <20061010164142.GA5360@oppetid.no> <25631.1160498572@sss.pgh.pa.us> <20061010170639.GB5360@oppetid.no> <25953.1160500192@sss.pgh.pa.us> <20061010171304.GC5360@oppetid.no> <26123.1160500707@sss.pgh.pa.us> <20061010174955.GA284@oppetid.no> <528.1160503495@sss.pgh.pa.us> <20061010181953.GA7584@oppetid.no> <772.1160504813@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <772.1160504813@sss.pgh.pa.us> Organization: Group Nordicbet User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.177 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200610/206 X-Sequence-Number: 21335 [Tom Lane - Tue at 02:26:53PM -0400] > > autovacuum_vacuum_cost_delay = 500 > > autovacuum_vacuum_cost_limit = 200 > > Well, that's going to cause it to sleep half a second after every dozen > or so page I/Os. I think you'd be well advised to reduce the delay. Modified it to 20/250, and it definitively helped. Sorry for the list verbosity; I should have been able to resolve this myself already some 2-3 emails ago :-) I wanted a "soft" introduction of autovac in production, and assumed that it was better to begin with too much sleep than too little! Well, well.