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 resu\
lts 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.
...
- Berkeley DB - 4.3.x
- MySQL - 45.10.710
- PostgreSQL - 8.0.1 3 (with pg_autovacuum running every 60 seconds)
Everything ran local to the box
- SDBM numbers are from using the following configuration setting with SA Run using Mail-SpamAssassin 3.1.0 (as yet unreleased):
...
- -RC1 release
Phase | SDBM.pm | Berkeley DBM | DBM (Berkeley DB/DB_File) | SQL.pm MySQL[ | MySQL.pmBRMySQL MyISAM]InnoDB MyISAM | PostgreSQL MySQL.pm[ | PostgreSQL PgSQL.pmBRInnoDB]fsync=fa\ | PgSQL.pmBRfalse]fsync=true | ||||||
1a | 86.12 | 82 124.88 94 | 120 375.10 97 | 399 163.55 92 | 429 184.00 65 | 1229 164.08 23 | 4445 222.54 | |||||||
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 | ||||||||
87.68 | 142.01 | 352.76 | 159.77 | 170.67 | 154.03 | 211.93 | ||||||||
2 | 530.39 | 1555.36 | 872.14 | 663.12 | 682.71 | 929.31 | 1149.92 | |||||||
3 | 18.38 | 49.47 | 9.18 | 9.34 | 9.78 | 6.79 | 8.69 | |||||||
4a | 36.82 | 61.56 | 218.99 | 146.36 | 377.80 | 202.19 | 253.36 | |||||||
4b | 37.14 | 60.23 | 201.49 | 146.36 | 381.26 | 196.09 | 242.49 | |||||||
5a | 273.90 | 902.26 | 547.98 | 364.13 | 380.06 | 507.15 | 710.41 | |||||||
5b | 193.95 | 443.86 | 284.70 | 228.32 | 233.19 | 316.11 | 432.08 | |||||||
total | 1264.39 | 3339.70 | 2862.54 | 1881.10 | 2420.13 | 2475.91 | 3231.41 | total | 1158.75 | 2683.66 | 2648.45 | 2920.76 | 5654.37 | 21806.60 |