Hi Mark, >>> I can prepare a small change to amavisd which would use >>> (partition_tag,mail_id) as a unique key instead of just the (mail_id). >>> ... >>> Do you think it would help? >> That would be great! (and probably also speed up amavisd's lookups >> without the need to add an additional key on mail_id) > > Ok, here it goes. The patch below changes SQL clauses to always join > tables using both the partition_tag and the mail_id fields. This has > no particular effect on existing 2.6.0 databases where a primary key > is mail_id (it is just a redundant condition), but saves a day > when a primary key is a composite (partition_tag,mail_id).
Thank you for your great work!! I'll switch my mail-traffic away from one of my filters within the next hours and test some domain on the patched amavisd-new in production. If everything goes well I'll switch the routing back and put the patch on all (both) current live filter hosts - even if doing so could waste my weekend ;-) Cheers, Thomas Gelf ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/