[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