Re: [Dspam-user] large email structure

2015-03-25 Thread Phil Stracchino
On 03/25/15 09:16, k...@rice.edu wrote: > It should > also be noted, that MyISAM also performs poorly for mixed read-write > activities due to the locking needed to coordinate access. Oh dear gods yes. In the benchmark sets I alluded to, we determined that, both properly configured with the same

Re: [Dspam-user] large email structure

2015-03-25 Thread k...@rice.edu
On Wed, Mar 25, 2015 at 09:03:54AM -0400, Phil Stracchino wrote: > On 03/25/15 08:48, k...@rice.edu wrote: > > On Wed, Mar 25, 2015 at 06:39:43AM -0300, j...@7lan.net wrote: > >> I'm planning to put it in a sql backend. What database does dspam works > >> better? I saw some postgresql schema optim

Re: [Dspam-user] large email structure

2015-03-25 Thread Phil Stracchino
On 03/25/15 08:48, k...@rice.edu wrote: > On Wed, Mar 25, 2015 at 06:39:43AM -0300, j...@7lan.net wrote: >> I'm planning to put it in a sql backend. What database does dspam works >> better? I saw some postgresql schema optimization, but maybe mysql is >> less resource eater? What are your experi

Re: [Dspam-user] large email structure

2015-03-25 Thread k...@rice.edu
On Wed, Mar 25, 2015 at 06:39:43AM -0300, j...@7lan.net wrote: > >> > >> I tryed to use postgresql driver, but it used a lot of resources. > >> > >> Can you guys give me some suggestions? The database is getting bigger > >> and I don't know if I'm doing the best maintenance routine. > >> > >> Th

Re: [Dspam-user] large email structure

2015-03-25 Thread joao
Em 2015-03-24 17:04, k...@rice.edu escreveu: > On Tue, Mar 24, 2015 at 03:57:01PM -0300, j...@7lan.net wrote: >> Hi, >> >> I'm using DSPAM in a 100.000 users e-email structure. I run 6 mail >> server with dspam with the hash driver. The database is kept in a NFS >> share and it seems to work fine.

Re: [Dspam-user] large email structure

2015-03-24 Thread k...@rice.edu
On Tue, Mar 24, 2015 at 03:57:01PM -0300, j...@7lan.net wrote: > Hi, > > I'm using DSPAM in a 100.000 users e-email structure. I run 6 mail > server with dspam with the hash driver. The database is kept in a NFS > share and it seems to work fine. > > I'm using TOE training mode, since I have am

[Dspam-user] large email structure

2015-03-24 Thread joao
Hi, I'm using DSPAM in a 100.000 users e-email structure. I run 6 mail server with dspam with the hash driver. The database is kept in a NFS share and it seems to work fine. I'm using TOE training mode, since I have amavis-new in this structure doing black/whitelist and common blocks. My users