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 F027BD1B51B for ; Thu, 16 Oct 2003 21:39:15 +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 93453-03 for ; Thu, 16 Oct 2003 18:38:47 -0300 (ADT) Received: from localhost.localdomain (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 9CC3FD1B4F2 for ; Thu, 16 Oct 2003 18:38:41 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by localhost.localdomain (8.12.8/8.12.8) with ESMTP id h9GKavqd024287; Thu, 16 Oct 2003 16:36:57 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h9GLcVZ32092; Thu, 16 Oct 2003 17:38:31 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id TD8AX8VP; Thu, 16 Oct 2003 17:38:28 -0400 Subject: Re: free space map usage From: Robert Treat To: jeremy.guthrie@berbee.com Cc: Tom Lane , "pgsql-performance@postgresql.org" In-Reply-To: <200310141447.05788.jeremy.guthrie@berbee.com> References: <200310141154.17227.jeremy.guthrie@berbee.com> <11798.1066158968@sss.pgh.pa.us> <200310141447.05788.jeremy.guthrie@berbee.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 16 Oct 2003 17:38:31 -0400 Message-Id: <1066340311.2070.1608.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/477 X-Sequence-Number: 4225 On Tue, 2003-10-14 at 15:43, Jeremy M. Guthrie wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On Tuesday 14 October 2003 02:16 pm, Tom Lane wrote: > > "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? > Yup. I still see no effect after restart. > Given that you knew of no way to determine how much free space map you were using, what is your criteria for it to "appear to be working"? If it's that space keeps growing, then your probably not vacuuming frequently enough. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL