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 16AFFD1B4FE for ; Tue, 14 Oct 2003 19:47:48 +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 76479-02 for ; Tue, 14 Oct 2003 16:47:18 -0300 (ADT) Received: from ctg-msnex01.staff.berbee.com (msn-office1.binc.net [64.73.12.254]) by svr1.postgresql.org (Postfix) with ESMTP id 92994D1B4E9 for ; Tue, 14 Oct 2003 16:47:15 -0300 (ADT) Received: from localhost ([172.30.254.220] RDNS failed) by ctg-msnex01.staff.berbee.com with Microsoft SMTPSVC(5.0.2195.5329); Tue, 14 Oct 2003 14:47:06 -0500 From: "Jeremy M. Guthrie" Reply-To: jeremy.guthrie@berbee.com Organization: Berbee Information Networks To: Tom Lane Subject: Re: free space map usage Date: Tue, 14 Oct 2003 14:43:53 -0500 User-Agent: KMail/1.5.4 Cc: "pgsql-performance@postgresql.org" References: <200310141154.17227.jeremy.guthrie@berbee.com> <11798.1066158968@sss.pgh.pa.us> In-Reply-To: <11798.1066158968@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Description: clearsigned data Content-Disposition: inline Message-Id: <200310141447.05788.jeremy.guthrie@berbee.com> X-OriginalArrivalTime: 14 Oct 2003 19:47:06.0625 (UTC) FILETIME=[F2B03710:01C3928B] X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/471 X-Sequence-Number: 4219 -----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 current= ly > > i=3D n=3D20 > > use?(ie. where and what it is tracking?) I vacuum on a regular basis b= ut > > I=3D =3D20 > > 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=3D# 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 =3D 178 = kB > shared memory. VACUUM > regression=3D# > > 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=3D20 > > 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. > regards, tom lane - --=20 Jeremy M. Guthrie Systems Engineer Berbee 5520 Research Park Dr. Madison, WI 53711 Phone: 608-298-1061 Berbee...Decade 1. 1993-2003 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/jFH8qtjaBHGZBeURAkKkAJ0cDa31C4VKxlHoByFaGY3EtQwMdwCgmA5k +Z9GUE3l7LIJVl9rII7d3TU=3D =3DgkIR -----END PGP SIGNATURE-----