[Maia-users] Message size limits ...

[Marc G. Fournier]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


I was just helping Chris Paul with some performance issues he's having with 
PostgreSQL+MAIA that, the more we looked into it, the less it made sense ...

As a reference, I use MAIA in an ISP scenario with all mail for hundreds of 
domains going through it, with the biggest domain being postgresql.org itself 
... my maia_mail database has >250k messages in it right now, and I have the 
Bayes database stored in PostgreSQL as well ...

In Chris' case, he has just over 200k messages, but doesn't store Bayes in the 
SQL database ... so less messages, and less processing in SQL ...

But .. while my database is about 2.5G in size, he's is >10G ...

For him, his clients need to be able to do "very large emails" ... checking:

SELECT max(size) FROM maia_mail;

on his system, his largest email message is ... 22M in size ... mine is <1M ...

Now, a spammer will generally not send large messages, because you can't send 
alot of very large messages very quickly ...

So, a feature / enhancement suggestion:

1. keep stats on max size of email that is actually deemed to be spam, so that
   the admin has a way of setting a limit

2. have a limit / variable setting that causes MAIA to skip messages over a
   certain size, not storing it in the database at all ...

Feature 1 could be used to give a guideline to Feature 2 ... ie. you could set 
F2 to 2xF1, to give a buffer in case of the occasional stray ...


- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy at hub.org                              MSN . scrappy at hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (FreeBSD)

iD8DBQFGNjKu4QvfyHIvDvMRAjsZAKChE9/SKq2aRQr24B0eckiV0XnE+QCgpdFf
TYPNB8YkUmBxJL1wi80Y6P8=
=7Tvn
-----END PGP SIGNATURE-----