Hey everyone,
While reading the doco for the pgsql driver i noticed it says to use 
purge-pe.sql script to purge stale tokens if TOE is used as user preference, 
which is what im using(the default is TUM which is set in dspam.conf). I only 
find purge.sql script which is ignorant of 
user preferences. I have compiled with preferences-extension and all, its a 
working system.

This is the purge.sql script that im using at the moment which is ignorant of 
user preferences.

DELETE FROM dspam_token_data
  WHERE (innocent_hits*2) + spam_hits < 5
  AND last_hit < CURRENT_DATE - 60;

DELETE FROM dspam_token_data
  WHERE innocent_hits = 1 AND spam_hits = 0
  AND last_hit < CURRENT_DATE - 15;

DELETE FROM dspam_token_data
  WHERE innocent_hits = 0 AND spam_hits = 1
  AND last_hit < CURRENT_DATE - 15;

DELETE FROM dspam_token_data
  WHERE last_hit < CURRENT_DATE - 90;

DELETE FROM dspam_signature_data
  WHERE created_on < CURRENT_DATE - 14;

VACUUM ANALYSE;

Thank you in advance.

Petr

Reply via email to