Versions Compared

Old Version 3

changes.mady.by.user ASF Infrabot

Saved on

compared with

New Version Current

changes.mady.by.user ASF Infrabot

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: converted to 1.6 markup

For the moment, this is just a dump of some benchmark 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.

...

Here is a test run, with 2000 msgs per bucket (1000 in the forget buckets).

System is SUSE Linux 9.12, 2.8 P4 (HyperThread) 512MB RAM w/ Perl v5.8.5

  • Berkeley DB - 4.23.52x
  • MySQL - 45.10.610
  • PostgreSQL - 78.4.50.3 (with pg_autovacuum running every 60 seconds)

Everything ran local to the box

  • Run using Mail-SpamAssassin 3.1.0-RC1 release


Phase

Berkeley DBM

SDBM.pm

DBM
(Berkeley DB/DB_File)

SQL.pm
MySQL MyISAM

MySQL.pm
MySQL - MyISAM

MySQL - InnoDB

PostgreSQL

1a

119.38

405.92

436.73

Not

1b

96.78

263.86

282.63

Done

 

 

 

 

Yet

2

1096.70

750.42

773.23

 

 

 

 

 

 

3

37.76

4.57

6.31

 

 

 

 

 

 

4a

68.35

188.38

364.84

 

4b

48.52

133.49

299.05

 

 

 

 

 

 

5a

789.34

499.41

522.77

 

.pm
InnoDB

PgSQL.pm
fsync=false

PgSQL.pm
fsync=true

1a

86.12

124.94

375.97

163.92

184.65

164.23

222.54

1b

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

5b

312.76

218.89

224.25