free space map usage - Mailing list pgsql-performance

From Jeremy M. Guthrie
Subject free space map usage
Date
Msg-id 200310141154.17227.jeremy.guthrie@berbee.com
Whole thread Raw
Responses Re: free space map usage
List pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Is there any way to determine how much of the free space map is currently in
use?(ie. where and what it is tracking?)  I vacuum on a regular basis but I
never hold in terms of disk space usage.  I jacked up the free space map
pages but this doesn't appear to be working.

shared_buffers = 29400        # 2*max_connections, min 16
max_fsm_relations = 1000    # min 10, fsm is free space map
max_fsm_pages = 10000000      # min 1000, fsm is free space map

- --
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/jCo4qtjaBHGZBeURAj9EAKCL+tiioPO5K1YM1sn62yS0L1Ry5QCfVifq
22s22gFNFHAHquS+iiUZO6s=
=AQ2Y
-----END PGP SIGNATURE-----

Attachment

pgsql-performance by date:

Previous
From: Rod Taylor
Date:
Subject: Re: sql performance and cache
Next
From: Wei Weng
Date:
Subject: Re: [SQL] sql performance and cache