[Babase] Database maintenance

Karl O. Pinc kop at meme.com
Fri Dec 11 01:17:23 EST 2009


Hi,

I found the database complaining that it could not
vacuum properly so changed the resource limits,
restarted the database, and vacuumed everything.

This may have been due to Lacey's long-running
updates to the males and the consequent large
numbers of simultaneous changes.  Or not.

So, the database may now be running better.
OTOH, it may be running worse because I did
make a change to the way resources are allocated.

Please let me know the good or the bad so we
can work out any kinks now and in the future.

-------------<snip>----------
For the record, the complaint was:

NOTICE:  number of page slots needed (477840) exceeds max_fsm_pages 
(400000)
HINT:  Consider increasing the configuration parameter "max_fsm_pages" 
to a value over 477840.

I increased max_fsm_pages to 550000.

Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein




More information about the Babase mailing list