You need to increase your max_fsm_pages to at least 29584 pages to accommodate / monitor all free pages. -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx]On Behalf Of Colton A Smith Sent: Thursday, 22 September 2005 8:00 a.m. To: pgsql-admin@xxxxxxxxxxxxxx Subject: vacuum message Hi: I did a vacuum verbose on my database and at the end of the output I got the following: INFO: free space map: 85 relations, 18940 pages stored; 29584 total pages needed DETAIL: Allocated FSM size: 1000 relations + 20000 pages = 186 kB shared memory. VACUUM Can somebody tell me what that means? Thanks! ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
