X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 408779DCCAF for ; Wed, 30 Nov 2005 10:56:07 -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 22851-01 for ; Wed, 30 Nov 2005 10:56:09 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from gauss.credativ.com (ipx11302.ipxserver.de [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id BA5A29DCC95 for ; Wed, 30 Nov 2005 10:56:03 -0400 (AST) Received: from bell.credativ.de (p50896679.dip.t-dialin.net [80.137.102.121]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 22789D764C for ; Wed, 30 Nov 2005 15:56:08 +0100 (CET) From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Confused about FSM numbers Date: Wed, 30 Nov 2005 15:56:48 +0100 User-Agent: KMail/1.8.2 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200511301556.48427.peter_e@gmx.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/345 X-Sequence-Number: 19718 I have never figured out what the FSM numbers printed by VACUUM VERBOSE really meant. I have for example, INFO: free space map: 101 relations, 150 pages stored; 1664 total pages needed What exactly does that last number mean? I have 20000 pages configured for the FSM, so if it needs 1664, why does it only take 150?