Re: Bayes-SQL improvements

2008-12-26 Thread Justin Mason
so you're basically sharding the bayes_token tables... could you open a bug on the SpamAssassin bugzilla with this patch? thanks! --j. Thorsten Meinl writes: >--nextPart9059977.pG6Pp7397c >Content-Type: multipart/mixed; > boundary="Boundary-01=_oj8UJ9IS8rBJw6M" >Content-Transfer-Encoding: 7bit

Bayes-SQL improvements

2008-12-25 Thread Thorsten Meinl
Hi all, We have an installation of Spamassassin that serves about 2000 users. Their Bayes-data is stored inside a Postgres database which is of fairly large size, the bayes_token table holds about 100 million rows. This often leads to high loads on the machine, especially if bayes_expire is run