Justin Mason wrote: > Is there any diff between Amavisd and spamd's use of SQL for bayes? > I wouldn't have thought so...
No, just the fact that it doesn't generally support (someone feel free to correct me if I'm wrong) individualized configs (ie everything runs as a single user). Anyone who attempts a sitewide database with that many children hitting the db at once will most likely encounter the same sort of difficulties. However, 4000 queries/sec is not very high (I can easily push that via 2 spamd children), so I'm actually guessing there is a broader issue here. Maybe amavisd is doing some additional, poorly optimized, queries that is causing the database slowness. Michael
signature.asc
Description: OpenPGP digital signature
