[Greylist-users] Periodic clean-up of the garbage triplets in the db?

Philip Kizer 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 mailing list