Re: Need some insight into the relayreport table.

Thanks!

--RayJ

Paul Venezia wrote:
> 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  
>> 5000
>> junk emails a day!
>>
>> There is one minor detail that might become a problem at some point.  
>> The
>> 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  
>> criteria:
>> 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.
>>
>> --RayJ
>>
>> _______________________________________________
>> Greylist-users mailing list
>> [email protected]
>> http://lists.puremagic.com/cgi-bin/mailman/listinfo/greylist-users
>>
>>     
>
> _______________________________________________
> Greylist-users mailing list
> [email protected]
> http://lists.puremagic.com/cgi-bin/mailman/listinfo/greylist-users
>
>