Dan, > Over the past few weeks, my company's mail server has been experiencing > high loads that result in SA skipping emails. I use a postgres database to > manage bayes, awl and userprefs. I am pretty sure that it is the bayes db > that is causing the high load ...
Are you using a general-purpose SQL module: bayes_store_module Mail::SpamAssassin::BayesStore::SQL or a dedicated and optimized: bayes_store_module Mail::SpamAssassin::BayesStore::PgSQL ? See file sql/README.bayes in the SA distribution. Mark