SQL schema question

Mark Martinec Mark.Martinec+amavis at ijs.si
Thu Jul 5 15:24:34 CEST 2012


> The modoboa *amavis* plugin currently supports versions 2.6.X. I'm
> trying to make it compatible with version 2.7 and more.
> It seems the SQL schema has been modified and I see that many forgein
> key definitions have been commented out, not removed.
> Mark, could you please give me explanation about this change? (or
> redirect me to an old thread is the question has already been asked)

It turned out that purging old records from amavis database with
foreign keys is much slower than purging each table individually
based on a partition_tag field. I think this was the main reason
for commenting out foreign keys. One can leave these in if desired.

Some other small changes to a schema are based on a thread:


More information about the amavis-users mailing list