<br><br><div class="gmail_quote">On Fri, May 29, 2009 at 5:31 PM, Kai Schaetzl <span dir="ltr"><<a href="mailto:maillists@conactive.com">maillists@conactive.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Zaeem Arshad wrote on Fri, 29 May 2009 16:10:44 +0600:<br>
<div class="im"><br>
> Can I get noticecable performance improvement by moving the bayesian<br>
> database to tmpfs? Currently, it's being stored at /root/.spamassassin which<br>
> happens to be an ext3 partition.<br>
<br>
</div>Maybe. But you have to regularly back it up and restore it once you reboot or<br>
lose tmpfs for other reasons. I would think you are better off with moving to<br>
SQL.</blockquote><div><br>Doesn't MS expire the database every 24 hours? <br> <br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
How big is the database at the moment? What's the data of<br>
"sa-learn --dump magic"?</blockquote><div><br>bayes_seen 21M<br>bayes_toks 9.3M<br><br>0.000 0 3 0 non-token data: bayes db version<br>0.000 0 131710 0 non-token data: nspam<br>
0.000 0 40140 0 non-token data: nham<br>0.000 0 469228 0 non-token data: ntokens<br>0.000 0 1241679918 0 non-token data: oldest atime<br>0.000 0 1243580885 0 non-token data: newest atime<br>
0.000 0 1243594258 0 non-token data: last journal sync atime<br>0.000 0 1243594283 0 non-token data: last expiry atime<br>0.000 0 691200 0 non-token data: last expire atime delta<br>
0.000 0 13745 0 non-token data: last expire reduction count<br> <br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
Have you determined *that* it is Bayes that is creating your asserted<br>
permonance problem?</blockquote><div><br>I am trying to speed up I/O wherever it is involved within my resources. Since, the bayes database is an oft accessed file, I would like to have it on a faster filesystem or tmpfs. <br>
</div></div><br>