[Bug 4400] PostgreSQL schema maintains unnecessary additional index

[bu...@issues.apache.org]

https://issues.apache.org/SpamAssassin/show_bug.cgi?id=4400

--- Comment #16 from Mark Martinec <Ma...@ijs.si> 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.