http://bugzilla.spamassassin.org/show_bug.cgi?id=3771
[EMAIL PROTECTED] changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #2335 is|0 |1
obsolete| |
------- Additional Comments From [EMAIL PROTECTED] 2004-10-21 21:27 -------
Created an attachment (id=2474)
--> (http://bugzilla.spamassassin.org/attachment.cgi?id=2474&action=view)
Patch File
New patch file. This makes the scan time go from 37 secs to around 1 sec per
message. Learn is around 1.3 messages per second.
The difference is that instead of doing a select/update where token in (list of
binary tokens) I do individual updates. My guess is that PostgreSQL doesn't
like that query with the bytea values in the list.
If someone is interested, I've got a logfile of all the statements and basic
statistics if someone is interested. There are a couple of them, before the
change and after, that total for around 10 gigs uncompressed and > 8.5 million
queries.
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
