Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 1C6D463429A for ; Mon, 2 Nov 2009 16:34:45 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 39301-10 for ; Mon, 2 Nov 2009 20:34:34 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from gv-out-0910.google.com (gv-out-0910.google.com [216.239.58.191]) by mail.postgresql.org (Postfix) with ESMTP id B543D634E44 for ; Mon, 2 Nov 2009 16:34:29 -0400 (AST) Received: by gv-out-0910.google.com with SMTP id y18so646280gvf.7 for ; Mon, 02 Nov 2009 12:34:27 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=OUaMCY1Ew+CEFgW0Q5nXlHc9D23MEJxqQb1OTBpH/Jk=; b=DD50NvISopeEO1rr3ZM7xnGzBobV4pB7Htrib89dmGJi0qfPK1C8ZMHrDq17iLpiTX iFEMTE9u7iftQD3W6jaBWXvNWbJRoar6dwE/ttR0JtQYl4JsZqckvB+kJlSsNHqhFQih u14GqYFwMln5Tq4keZIyjZeU2yToQyrdEO0Gg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=QJoJs0fNsKFvuxBWoJONHPQ1JwwsUNn9QRNHU1GHIMMCgCtvh7sI/zZz7EO6aFpLaU kcRzlm/FBkB0Q3zEsC/V7OB9KEfTPuKPB5R2N+2rBIKMgtqeVDv2pu0ROce2bgZ5w2Uf jhSnOL2CpbIS/3n2Nb+UNXS74A+mRFNanC6tY= MIME-Version: 1.0 Received: by 10.239.170.35 with SMTP id q35mr576871hbe.150.1257194067137; Mon, 02 Nov 2009 12:34:27 -0800 (PST) In-Reply-To: <20091102125054.GA25608@pme.intranet.prolan.hu> References: <20091029144405.GA3755@pme.intranet.prolan.hu> <20091102125054.GA25608@pme.intranet.prolan.hu> Date: Mon, 2 Nov 2009 15:34:27 -0500 Message-ID: <603c8f070911021234w987bc75td160dc91114f16fd@mail.gmail.com> Subject: Re: database size growing continously From: Robert Haas To: Peter Meszaros Cc: Scott Marlowe , pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200911/15 X-Sequence-Number: 36183 On Mon, Nov 2, 2009 at 7:50 AM, Peter Meszaros wrote: > Increasing max_fsm_pages can be also helpful, but I've read that > 'vacuum verbose ...' will issue warnings if max_fsm_pages is too small. > I've never seen such messag, this command is either run and finish or > goes to an endless loop as it was written in my initial e-mail. I don't think it goes into an endless loop. I think it runs for a really long time because your database is bloated, in need of vacuuming, and probably has blown out the free space map. But since you haven't let it run to completion you haven't seem the message. ...Robert