amavis quarantine table question

Jernej Porenta via amavis-users amavis-users at
Mon Feb 24 18:36:13 CET 2014

On 24/02/14 14:51, Deeztek Support via amavis-users wrote:
> The documentation states that in the quarantine table the mail_text
> column should be of data type blob instead of text as it was suggested
> before. However, data type blob cannot be indexed will full text in
> mysql thus queries against the mail_text column take a ridiculous amount
> of time to complete. If I was to change the data type to text, what
> effect if any would this have to the functionality of amavis in general?

What kind of information are you extracting from quarantine table?

IMHO, other tables - msgs, msgrcpt, maddr - provide enough information 
for (at least my) "full" text search queries.

cheers, J.

More information about the amavis-users mailing list