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 |
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! |