Seems like my 'males' queries are taking about the same amount of time to run :) Nothing broken there<div>Thanks</div><div>L<br><div><br><div class="gmail_quote">On Fri, Dec 11, 2009 at 1:55 PM, Susan Alberts <span dir="ltr"><<a href="mailto:alberts@duke.edu">alberts@duke.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">OK thanks Karl we will keep you posted.<br>
S<div><div></div><div class="h5"><br>
<br>
On Dec 11, 2009, at 1:17 AM, Karl O. Pinc wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
I found the database complaining that it could not<br>
vacuum properly so changed the resource limits,<br>
restarted the database, and vacuumed everything.<br>
<br>
This may have been due to Lacey's long-running<br>
updates to the males and the consequent large<br>
numbers of simultaneous changes. Or not.<br>
<br>
So, the database may now be running better.<br>
OTOH, it may be running worse because I did<br>
make a change to the way resources are allocated.<br>
<br>
Please let me know the good or the bad so we<br>
can work out any kinks now and in the future.<br>
<br>
-------------<snip>----------<br>
For the record, the complaint was:<br>
<br>
NOTICE: number of page slots needed (477840) exceeds max_fsm_pages<br>
(400000)<br>
HINT: Consider increasing the configuration parameter "max_fsm_pages"<br>
to a value over 477840.<br>
<br>
I increased max_fsm_pages to 550000.<br>
<br>
Karl <<a href="mailto:kop@meme.com" target="_blank">kop@meme.com</a>><br>
Free Software: "You don't pay back, you pay forward."<br>
-- Robert A. Heinlein<br>
<br>
<br>
_______________________________________________<br>
Babase mailing list<br>
<a href="mailto:Babase@www.eco.princeton.edu" target="_blank">Babase@www.eco.princeton.edu</a><br>
<a href="http://www.eco.princeton.edu/mailman/listinfo/babase" target="_blank">http://www.eco.princeton.edu/mailman/listinfo/babase</a><br>
</blockquote>
<br></div></div>
------------------------------------------------------------<br><font color="#888888">
Susan Alberts, Dept of Biology, Duke University, Box 90338, Durham NC 27708. Phone 919-660-7272, FAX 919-660-7293</font><div><div></div><div class="h5"><br>
<br>
<br>
<br>
_______________________________________________<br>
Babase mailing list<br>
<a href="mailto:Babase@www.eco.princeton.edu" target="_blank">Babase@www.eco.princeton.edu</a><br>
<a href="http://www.eco.princeton.edu/mailman/listinfo/babase" target="_blank">http://www.eco.princeton.edu/mailman/listinfo/babase</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>- -<br>Lacey K. Maryott Roerish<br>Alberts Lab<br>Department of Biology<br>Duke University<br>ph: 919-660-7306<br>fax: 919-660-7293<br><a href="mailto:Lacey.Maryott@duke.edu">Lacey.Maryott@duke.edu</a><br>
</div></div>