https://issues.apache.org/SpamAssassin/show_bug.cgi?id=4400
--- Comment #16 from Mark Martinec <[email protected]> 2010-06-10 13:40:38 EDT --- Now that I have finally switched our bayes from MySQL back to PostgreSQL (thanks to improvements by Bug 6447 and Bug 6444), I am again in position to evaluate this proposal. This looks very promising - even with our current smallish set of 5000 tokens that accumulated over the last two days, the speedup by the proposed change is over 5% for token lookups (lookups on 3500 tokens of real mail). I'm sure this figure will grow as our set of tokens increases - so, watch this space... To summarize the proposal here: -- Drop the secondary index drop index bayes_token_idx1; -- Drop the old primary key alter table bayes_token drop constraint bayes_token_pkey; -- Add the goodnew primary key alter table bayes_token add constraint bayes_token_pkey primary key (token, id); -- Configure bugmail: https://issues.apache.org/SpamAssassin/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug.
