[Babase] Database maintenance
Susan Alberts
alberts at duke.edu
Fri Dec 11 13:55:28 EST 2009
OK thanks Karl we will keep you posted.
S
On Dec 11, 2009, at 1:17 AM, Karl O. Pinc wrote:
> 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
>
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
------------------------------------------------------------
Susan Alberts, Dept of Biology, Duke University, Box 90338, Durham NC
27708. Phone 919-660-7272, FAX 919-660-7293
More information about the Babase
mailing list