You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by "Dan Mahoney, System Admin" <da...@prime.gushi.org> on 2005/05/17 12:18:28 UTC
SQL AWL Auto-Expiry
Something about handling more than 10000 messages a day has made me decide
to run spamd on a different box and go client/server with this thing, with
full SQL.
Anyway, silly basic question. Is there something "automagic" about expiry
of AWL entries? Or is there just some query I can run periodically?
Should I add a timestamp data type and work based on that?
-Dan
--
--------Dan Mahoney--------
Techie, Sysadmin, WebGeek
Gushi on efnet/undernet IRC
ICQ: 13735144 AIM: LarpGM
Site: http://www.gushi.org
---------------------------
Re: SQL AWL Auto-Expiry
Posted by Michael Parker <pa...@pobox.com>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Dan Mahoney, System Admin wrote:
> Something about handling more than 10000 messages a day has made me
> decide to run spamd on a different box and go client/server with this
> thing, with full SQL.
>
No automatic AWL expiry.
> Anyway, silly basic question. Is there something "automagic" about
> expiry of AWL entries? Or is there just some query I can run
> periodically? Should I add a timestamp data type and work based on that?
>
With SQL based AWL it is very easy to do this yourself, there are some
recipes in the SQL presentation here:
http://people.apache.org/~parker/presentations/
Michael
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFCijRrG4km+uS4gOIRAuZuAJ9diaa81TAW0gQ4g2ZflZpnrFmbtgCfY23f
R4gl/+4w1GjjnYOlRV81WNY=
=9FsO
-----END PGP SIGNATURE-----