Hi, I am hoping someone here has run into this before, I didn't see anything worth while (or that I understood) via a google search.
I guess specs first. I have running OpenBSD 4.2-stable with postgres 8.2.4. The database itself runs fine, but when I go to run a 'full vaccum' to reclaim space I get the following error, which appears to require me to rebuild the kernel. I am looking for some input on this before I break something. Thanks, here's the error from the logs below. WARNING: relation "pg_toast.pg_toast_17723" contains more than "max_fsm_pages" pages with useful free space HINT: Consider compacting this relation or increasing the configuration parameter "max_fsm_pages". INFO: free space map contains 181258 pages in 12 relations DETAIL: A total of 179200 page slots are in use (including overhead). 5618000 page slots are required to track all free space. Current limits are: 179200 page slots, 1000 relations, using 1115 kB. NOTICE: number of page slots needed (5618000) exceeds max_fsm_pages (179200) HINT: Consider increasing the configuration parameter "max_fsm_pages" to a value over 5618000. Aug 12 20:46:26 logdb savecore: no core dump Aug 12 20:46:29 logdb postgres[30182]: [1-1] FATAL: could not create shared memory segment: Invalid argument Aug 12 20:46:29 logdb postgres[30182]: [1-2] DETAIL: Failed system call was shmget(key=4225001, size=74702848, 03600). Aug 12 20:46:29 logdb postgres[30182]: [1-3] HINT: This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parameter. Aug 12 20:46:29 logdb postgres[30182]: [1-4] You can either reduce the request size or reconfigure the kernel with larger SHMMAX. To reduce the request size (currently Aug 12 20:46:29 logdb postgres[30182]: [1-5] 74702848 bytes), reduce PostgreSQL's shared_buffers parameter (currently 4096) and/or its max_connections parameter (currently Aug 12 20:46:29 logdb postgres[30182]: [1-6] 200). Aug 12 20:46:29 logdb postgres[30182]: [1-7] If the request size is already small, it's possible that it is less than your kernel's SHMMIN parameter, in which case raising Aug 12 20:46:29 logdb postgres[30182]: [1-8] the request size or reconfiguring SHMMIN is called for. Aug 12 20:46:29 logdb postgres[30182]: [1-9] The PostgreSQL documentation contains more information about shared memory configuration.