X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D86ACD1B4ED for ; Tue, 14 Oct 2003 19:16:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 66999-06 for ; Tue, 14 Oct 2003 16:16:11 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id C2BC7D1B53C for ; Tue, 14 Oct 2003 16:16:09 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id h9EJG9hn011799; Tue, 14 Oct 2003 15:16:09 -0400 (EDT) To: jeremy.guthrie@berbee.com Cc: "pgsql-performance@postgresql.org" Subject: Re: free space map usage In-reply-to: <200310141154.17227.jeremy.guthrie@berbee.com> References: <200310141154.17227.jeremy.guthrie@berbee.com> Comments: In-reply-to "Jeremy M. Guthrie" message dated "Tue, 14 Oct 2003 11:54:16 -0500" Date: Tue, 14 Oct 2003 15:16:08 -0400 Message-ID: <11798.1066158968@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/466 X-Sequence-Number: 4214 "Jeremy M. Guthrie" writes: > Is there any way to determine how much of the free space map is currently i= > n=20 > use?(ie. where and what it is tracking?) I vacuum on a regular basis but I= > =20 > never hold in terms of disk space usage. Not in 7.3 AFAIR. In 7.4 a full-database VACUUM VERBOSE will end with the info you want: regression=# vacuum verbose; ... much cruft ... INFO: free space map: 11 relations, 144 pages stored; 272 total pages needed DETAIL: Allocated FSM size: 1000 relations + 20000 pages = 178 kB shared memory. VACUUM regression=# This tells me I'm only using about 1% of the FSM space (272 out of 20000 page slots). > I jacked up the free space map=20 > pages but this doesn't appear to be working. You know you have to restart the postmaster to make those changes take effect, right? regards, tom lane