For the moment, this is just a dump of some BayesBenchmark results. Eventually, I'd like to fix up this page so others can easily add their benchmark results for different setups and backends.
All numbers are the average for three runs of the benchmark (except the PostgreSQL fsync=false run, it took too long in the first place). All times are in seconds.
Here is a test run, with 2000 msgs per bucket (1000 in the forget buckets).
System is SUSE Linux 9.2, 2.8 P4 (HyperThread) 512MB RAM w/ Perl v5.8.5
- Berkeley DB - 4.3.x
- MySQL - 4.1.7
- PostgreSQL - 8.0.1 (with pg_autovacuum running)
Everything ran local to the box
- SDBM numbers are from using the following configuration setting with SA 3.1.0 (as yet unreleased):
bayes_store_module Mail::SpamAssassin::BayesStore::SDBM
Phase |
SDBM |
Berkeley DBM |
MySQL[ |
MySQLBRMyISAM]InnoDB |
PostgreSQL[ |
PostgreSQLBRfsync=false]fsync=true |
1a |
82.88 |
120.10 |
399.55 |
429.00 |
1229.08 |
4445 |
1b |
65.83 |
98.41 |
261.20 |
279.71 |
919.98 |
3051.50 |
2 |
497.33 |
1151.58 |
743.53 |
784.08 |
1357.86 |
5664 |
3 |
14.03 |
40.03 |
9.23 |
6.74 |
6.42 |
9.10 |
4a |
35.25 |
65.06 |
288.81 |
369.57 |
429.12 |
2082.32 |
4b |
28.27 |
46.61 |
241.51 |
301.66 |
343.07 |
1122.40 |
5a |
261.14 |
803.19 |
481.69 |
517.21 |
948.10 |
4304 |
5b |
174.01 |
358.67 |
222.93 |
232.79 |
420.74 |
1128.28 |
total |
1158.75 |
2683.66 |
2648.45 |
2920.76 |
5654.37 |
21806.60 |