[check_postgres] FSM checks

[Robert Treat]

On Thursday 25 September 2008 20:03:56 Jeff Frost wrote:
> 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

What version of postgres are you on? 

Can you give me the output of the following query:
select sum(interestingpages), sum(storedpages), 
sum(greatest(interestingpages,storedpages)) from pg_freespacemap_relations; 

-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL