[Greylist-users] Need some insight into the relayreport table.
pvenezia at jpj.net
Sat Mar 1 19:50:19 PST 2008
Go for it. Add WHERE origin_type = AUTO just to be safe.
On Mar 1, 2008, at 9:19 PM, RayJ wrote:
> Greetings all!
> I have just upgraded to Version: 0.05 prerelease and all is working as
> it should.
> RelayDelay has nearly eliminated our spam problem, preventing over
> junk emails a day!
> There is one minor detail that might become a problem at some point.
> relayreport table seems to collect data and is never trimmed to remove
> outdated records. There are currently over 4.6 million record in that
> table. The only place that I see that table accessed is in the
> db_maintenance.pl cron/script. So it looks like it just stores data.
> I would like to remove "outdated" records that fit the following
> last_update > 36 days old
> blocked_count = 1
> passed_count = 0
> I can write the query myself, I just wanted to be sure that this would
> not cause any problems with the functionality of the system.
> Thanks for any info/insight.
> Greylist-users mailing list
> Greylist-users at lists.puremagic.com
More information about the Greylist-users