PDA

View Full Version : PostgreSQL Question



Rhibee
06-10-2009, 07:05 PM
I have about 2 months worth of datamined hands on my computer so my database is pretty big - around 22gb.

When running my daily PGadmin vacuum I noticed the following message:

INFO: analyzing "public.holecards"
INFO: "holecards": scanned 32 of 32 pages, containing 5916 live rows and 0 dead rows; 3000 rows in sample, 5916 estimated total rows
INFO: free space map contains 157973 pages in 89 relations
DETAIL: A total of 204800 page slots are in use (including overhead).
210720 page slots are required to track all free space.
Current limits are: 204800 page slots, 1000 relations, using 1269 kB.
NOTICE: number of page slots needed (210720) exceeds max_fsm_pages (204800)
HINT: Consider increasing the configuration parameter "max_fsm_pages" to a value over 210720.

What size would you recommend I increase "max_fsm_pages" to and where do I do this?

fabio
06-10-2009, 10:04 PM
Not sure, I searched via google and didn't find anything helpful. I would leave everything as it is

Rhibee
06-11-2009, 05:10 AM
Thank you.