Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 1690164FC7D for ; Sun, 30 Nov 2008 13:51:45 -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 13784-01 for ; Sun, 30 Nov 2008 13:51:42 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 9448464FC02 for ; Sun, 30 Nov 2008 13:51:42 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id mAUHpMUR016625; Sun, 30 Nov 2008 12:51:22 -0500 (EST) To: =?ISO-8859-2?Q?Adam_Rad=B3owski?= cc: pgsql-admin@postgresql.org Subject: Re: max_fsm_relations In-reply-to: <493225F2.1080307@informatyka.gdansk.pl> References: <493225F2.1080307@informatyka.gdansk.pl> Comments: In-reply-to =?ISO-8859-2?Q?Adam_Rad=B3owski?= message dated "Sun, 30 Nov 2008 06:34:42 +0100" Date: Sun, 30 Nov 2008 12:51:22 -0500 Message-ID: <16624.1228067482@sss.pgh.pa.us> From: Tom Lane 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: 200811/178 X-Sequence-Number: 30832 =?ISO-8859-2?Q?Adam_Rad=B3owski?= writes: > PostgreSQL 8.1.3 (windows), 8.1.9 - 8.1.10 (linux). > I have databases, what are vacuumed using cron very regularry (vacuumdb > -a -f ...) and I know when should do this. Automatic vacuuming is off. > There are thousands of tables in one cluster (for ex. 10000). If I do > vacuuming manually, I can see the warning: > NOTICE: max_fsm_relations(1000) equals the number of relations checked > HINT: You have at least 1000 relations. Consider increasing the > configuration parameter "max_fsm_relations". > But all is working properly. Only for small values of "properly". You will be seeing table bloat over time if you don't make the FSM large enough. regards, tom lane