> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Mark Martinec > Sent: Tuesday, June 13, 2006 8:39 AM > To: amavis-user@lists.sourceforge.net > Subject: Re: [AMaViS-user] Pre-release of > amavisd-new-2.4.2,pen pals soft-whitelisting > > Michael, > At sites with lots of traffic I would recommend to place SQL > logging to a PostgreSQL: the purging of outdated records > seems to be MUCH faster that in MySQL. Don't know why.
I had tried postgrsql FIRST (had to do a lot of mucking around with table creates to get it to work) Seemed to work ok. But had another application on same system that didn't seem to like postgres all that well. I saw lots of information about optimizing mysql, but not much on optimizing postgres. Also, found a couple of sites that had some statistics showing (contrary to what I had thought) that postgres didn't scale well. I liked postgres for the transactional triggers, but in the end, found it caused problems with other application (amavis worked just fine) -- Michael Scheidell, CTO SECNAP Network Security 561-999-5000 x 1131 www.secnap.com _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
