Mark Martinec schrieb: > 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) > PostgreSQL is 'half-way' to supporting partitions - it bends > its optimizer to make it behave like you have partitions. > Because of this and because PostgreSQL is an order of magnitude > faster in purging amavisd database, I doubt anybody has > ventured into that territory yet. Ok, I got it - but... I like the role of the lonely wolf ;-) Lahko noč! Thomas ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
