On 26-02-14 17:35, Peter Milesson wrote:
>
>
> On 2014-02-26 17:23, Gray, Patrick wrote:
>> Just counted how many headervalues are in my dbmail_headervalue table.
>>
>> It looks to be somewhere arund 32 million.
>>
>> Could the sheer amount of the headervalues be causing dbmail-util to sit
>> there and not appear to be doing anything?
>>
>> Thanks for your help.
>>
>
> Hi Patrick,
>
> Probably, yes. I've got almost 1.9 million records, and the cleanup
> takes a while. Most notably the headervalues take most of the time. I'm
> running a Xen domU mail server with Postfix/Amavis/ClamAV as front end.
> 2 VCPUs, plenty of disk, and too little memory ;-)
I've been adding some functionality to the master branch to deal with
this problem. In the future, it will be possible to stop caching *all*
headers, and just cache headers whose headername (Subject, To, CC, etc)
is already known in the dbmail_headername table.
Once that is in place you can start deleting rows from the
dbmail_headername table and not worry about values being re-inserted
when new messages come in.
--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, github, linkedin
www.nfg.nl/i...@nfg.nl/+31.85.877.99.97
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
