Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9022164FC94 for ; Mon, 1 Dec 2008 12:44:07 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 00256-06 for ; Mon, 1 Dec 2008 12:44:04 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ns1.peker.com.pl (ns1.peker.com.pl [62.121.85.181]) by mail.postgresql.org (Postfix) with SMTP id 3A5BA64FC4F for ; Mon, 1 Dec 2008 12:44:01 -0400 (AST) Received: (qmail 6283 invoked by uid 540); 1 Dec 2008 17:00:28 -0000 Received: from 89.206.3.18 by ns1.peker.com.pl (envelope-from , uid 401) with qmail-scanner-1.25st (clamdscan: 0.82/760. spamassassin: 3.0.2. perlscan: 1.25st. Clear:RC:1(89.206.3.18):. Processed in 0.071654 secs); 01 Dec 2008 17:00:28 -0000 Received: from host18-89-206-3.limes.com.pl (HELO ?192.168.1.2?) (informatyka-adamr@89.206.3.18) by ns1.peker.com.pl with SMTP; 1 Dec 2008 17:00:27 -0000 Message-ID: <49341427.7020601@informatyka.gdansk.pl> Date: Mon, 01 Dec 2008 17:43:19 +0100 From: =?UTF-8?B?QWRhbSBSYWTFgm93c2tp?= User-Agent: Thunderbird 2.0.0.9 (X11/20071031) MIME-Version: 1.0 To: Alvaro Herrera CC: Tom Lane , pgsql-admin@postgresql.org Subject: Re: max_fsm_relations References: <493225F2.1080307@informatyka.gdansk.pl> <16624.1228067482@sss.pgh.pa.us> <4932EEF9.60603@informatyka.gdansk.pl> <20081201131731.GB4459@alvh.no-ip.org> In-Reply-To: <20081201131731.GB4459@alvh.no-ip.org> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/4 X-Sequence-Number: 30837 Now I got full information. Big thanks. Adam Alvaro Herrera pisze: > Adam Radłowski wrote: >> So, are You suggesting, that at the time of full database vacuuming, >> some of tables are not vacuumed, when "max_fsm_relations" is to small ? > > No. They will all be vacuumed. The difference is that the space > reclaimed by vacuum will not be reused unless it is recorded by the FSM. >