[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