[Babase] Database maintenance

Lacey Maryott Roerish lroerish4 at gmail.com
Fri Dec 11 13:58:32 EST 2009


Seems like my 'males' queries are taking about the same amount of time to
run :) Nothing broken there
Thanks
L

On Fri, Dec 11, 2009 at 1:55 PM, Susan Alberts <alberts at duke.edu> wrote:

> 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
>
>
>
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
>



-- 
- -
Lacey K. Maryott Roerish
Alberts Lab
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://eeblistserv.Princeton.EDU/pipermail/babase/attachments/20091211/d75b4d20/attachment.html


More information about the Babase mailing list