> There are some incompatibilities with 2.5.3 (mainly affecting SQL
> logging/quarantining tables), please see release notes.
Should a need arise to switch from 2.6.0 back to 2.5.3 after
adding a field 'partition_tag' to SQL tables and adjusting
the UNIQUE constraint with its index on table maddr,
the following patch to 2.5.3 (or 2.5.2) is needed, otherwise
a SELECT on maddr can be very slow in the absence of an index:
--- amavisd-2.5.3~ Wed Dec 12 12:33:54 2007
+++ amavisd-2.5.3 Wed Dec 12 12:36:29 2007
@@ -900,5 +900,5 @@
'sel_wblist' => \$sql_select_white_black_list,
'sel_adr' =>
- 'SELECT id FROM maddr WHERE email=?',
+ 'SELECT id FROM maddr WHERE partition_tag=0 AND email=?',
'ins_adr' =>
'INSERT INTO maddr (email, domain) VALUES (?,?)',
Mark
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
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/
