free space map usage

Поиск
Список
Период
Сортировка
От Jeremy M. Guthrie
Тема free space map usage
Дата
Msg-id 200310141154.17227.jeremy.guthrie@berbee.com
обсуждение исходный текст
Ответы Re: free space map usage  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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-----

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: sql performance and cache
Следующее
От: Wei Weng
Дата:
Сообщение: Re: [SQL] sql performance and cache