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 8AB4F9DCC70 for ; Wed, 30 Nov 2005 11:16:23 -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 24228-04 for ; Wed, 30 Nov 2005 11:16:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 987A49DCC28 for ; Wed, 30 Nov 2005 11:16:20 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jAUFGJxc016684; Wed, 30 Nov 2005 10:16:20 -0500 (EST) To: Peter Eisentraut cc: pgsql-admin@postgresql.org Subject: Re: Confused about FSM numbers In-reply-to: <200511301556.48427.peter_e@gmx.net> References: <200511301556.48427.peter_e@gmx.net> Comments: In-reply-to Peter Eisentraut message dated "Wed, 30 Nov 2005 15:56:48 +0100" Date: Wed, 30 Nov 2005 10:16:19 -0500 Message-ID: <16683.1133363779@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.004 required=5 tests=[AWL=0.004] X-Spam-Score: 0.004 X-Spam-Level: X-Archive-Number: 200511/346 X-Sequence-Number: 19719 Peter Eisentraut writes: > 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? The FSM allocations are quantized (16 pages per chunk IIRC). So to store one page for each of 101 relations you'd need 1616 page slots. It looks like you have three more chunks than the minimum, so some of those relations have more than 16 pages with free space, but not very many ... regards, tom lane