It appears that you are user per user bayes.  If you have a large number
of users and performance is becoming an issue you might want to change
over to site wide bayes and disable per user.

As for user purging, no, there is no user detection to process users
that are no longer in the system.

> -----Original Message-----
> From: Jason Frisvold [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 21, 2006 6:54 AM
> To: users@spamassassin.apache.org
> Subject: SQL Bayes
> 
> Greetings,
> 
> I'm looking for some fine tuning help.  It seems that we are currently
> I/O limited due to the massive load spamassassin puts on the bayes
> database.  The database is currently about 3.5 Gig, including indices.
> 
> I have a few questions regarding the operation of Bayes.
> 
> 1) How effective is it really?  Will users likely notice a huge change
> if bayes was disabled?
> 
> 2) Purging.  I know bayes purges itself regularly.  However, if a user
> is removed from the mail server, and bayes is never run for that user
> again, will those tokens automatically be purged after a time?  Or
> will they be stuck there forever?  In the case of the latter, how do I
> manually purge those?
> 
> 3) Any thoughts on speeding up the database calls?  Is faster hard
> drives/clustering my only option?
> 
> Thanks!
> 
> --
> Jason 'XenoPhage' Frisvold
> [EMAIL PROTECTED]

Reply via email to