X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 758829DCBC4 for ; Mon, 27 Feb 2006 11:03:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37378-04 for ; Mon, 27 Feb 2006 11:03:48 -0400 (AST) 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 785B59DCB4C for ; Mon, 27 Feb 2006 11:03:42 -0400 (AST) Received: from deimos.muc.ecircle.de (deimos.muc.ecircle.de [192.168.1.4]) by mail.ecircle.de (READY) with ESMTP id 1FE3855C008; Mon, 27 Feb 2006 16:03:47 +0100 (CET) Received: from [192.168.1.110] ([192.168.1.110]) by deimos.muc.ecircle.de with Microsoft SMTPSVC(5.0.2195.6713); Mon, 27 Feb 2006 16:03:46 +0100 Subject: Re: neverending vacuum From: Csaba Nagy To: Alvaro Herrera Cc: postgres performance list In-Reply-To: <20060227143153.GC5755@surnet.cl> References: <1141047092.6846.256.camel@coppola.muc.ecircle.de> <20060227143153.GC5755@surnet.cl> Content-Type: text/plain Message-Id: <1141052619.6846.263.camel@coppola.muc.ecircle.de> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 27 Feb 2006 16:03:40 +0100 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 27 Feb 2006 15:03:46.0585 (UTC) FILETIME=[02053890:01C63BAF] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.105 required=5 tests=[AWL=0.105] X-Spam-Score: 0.105 X-Spam-Level: X-Archive-Number: 200602/417 X-Sequence-Number: 17403 > So one very effective way of speeding this process up is giving the > vacuum process lots of memory, because it will have to do fewer passes > at each index. How much do you have? OK, this is my problem... it is left at default (16 megabyte ?). This must be a mistake in configuration, on other similar boxes I set this to 262144 (256 megabyte). The box has 4 Gbyte memory. Thanks for the explanation - you were right on the spot, it will likely solve the problem. Cheers, Csaba.