free space map usage

From: "Jeremy M(dot) Guthrie" <jeremy(dot)guthrie(at)berbee(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: free space map usage
Date: 2003-10-14 16:54:16
Message-ID: 200310141154.17227.jeremy.guthrie@berbee.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
image/png 17.3 KB

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2003-10-14 17:09:26 Re: go for a script! / ex: PostgreSQL vs. MySQL
Previous Message Tom Lane 2003-10-14 16:52:57 Re: [HACKERS] Sun performance - Major discovery!