[check_postgres] FSM checks

Jeff Frost jeff at frostconsultingllc.com
Fri Sep 26 00:03:56 UTC 2008


The new FSM checks don't seem to agree with vacuum verbose:

CPU 0.00s/0.00u sec elapsed 0.01 sec.
INFO:  free space map contains 214803 pages in 849 relations
DETAIL:  A total of 226592 page slots are in use (including overhead).
226592 page slots are required to track all free space.
Current limits are:  2000000 page slots, 1000 relations, using 11823 kB.

discord:~/git/check_postgres $ ./check_postgres.pl --action fsm_pages --db=postgres
POSTGRES_FSM_PAGES WARNING:  fsm page slots used: 1722880 of 2000000 (86%) | time=0.01

POSTGRES_FSM_RELATIONS WARNING:  fsm relations used: 855 of 1000 (86%) | time=0.03

The relations seems pretty close, but the pages are pretty far off:

226592
vs
1722880

-- 
Jeff Frost, Owner 	<jeff at frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 916-647-6411	FAX: 916-405-4032


More information about the Check_postgres mailing list