Periodic clean-up of the garbage triplets in the db?
pckizer at nostrum.com
Mon Jun 23 19:40:05 PDT 2003
I've only got 3000 triplets after running since Saturday, but a friend of
mine that I was assisting already has 20,000 triplets in his DB after 4
hours. Particularly given the "garbage" spam sender addresses that are
used, we were thinking of performing some kind of clean-up like the
following every $time_period (hour, day, etc):
delete from relaytofrom where record_expires < NOW();
or, for safety, perhaps something like:
delete from relaytofrom where record_expires < NOW()
and origin_type != 'MANUAL';
Comments or suggestions?
More information about the Greylist-users