Kenneth Marshall schrieb: > On Sun, Mar 11, 2007 at 09:30:55AM +0100, Norman wrote: > >> Hi guys, >> >> im using dspam now since version 2.x and im realy happy with it. At the >> moment im using mysql for storage. Now after switching to psotgresql 8.x >> for some user db stuff i'm intressted if dspam is "usable" with >> postgresql in 3.6.8. >> >> I remember there were some "performance" issues with dspam and >> postgresql in the past. >> >> Thx for the help >> >> bye >> Norman >> >> >> > Norman, > > We are running DSPAM 3.6.8 currently against a MySQL DB. For a number > of reasons, we would like to use PostgreSQL as the backend DB. First, > our setup allows everyone to have a private training information for > about 10k accounts. This results in very large token databases and > causes effectively random I/O. We have tried using different versions > of PostgreSQL to see if it could meet our needs, but the type of > updates that DSPAM depends upon is one of the poorer performing > queries on PostgreSQL. That being said, PostgreSQL performance has > improved dramatically since we first started benchmarking it with > our DSPAM instance and myself and others have posted some performance > patches for DSPAM and tuning tips for the database backend. The > current release 8.1 came very close to actually being able to support > our installation and I although I have not tested it because the timing > of the release was bad, 8.2 would probably have worked. The very good > news is that the upcoming 8.3 release includes update support for the > exact type of updates that DSPAM uses and we are planning to migrate > our backend DBs from MySQL to PostgreSQL at that time, should testing > bear out our expectations. > > Note, that our installation creates a large DB load because of the > individual training corpuses. If you have fewer accounts or otherwise > group your training, the current release is suitable. If you use any > type of groups with DSPAM, be sure to include the patch that I posted > a while back. Let me know if you have any more questions. > > Ken >
Hi Ken, thx for your information. Did you know if there is any chance for your patch to get included in next dspam release? I know it was really "quite" in the dspam developer camp the last month but let us hope there will be more releases soon again. bye Norman
