Lars Kneschke wrote:
Justin McAleer <[EMAIL PROTECTED]> schrieb:
Mysql: 95 seconds to deliver all 1000 messages. Both cores
on the DB server were effectively peaked during delivery.
Postgres: 10 seconds to deliver all 1000 messages. DBMail
was really close to being able to deliver as fast as
postfix could queue to local disk (within a second or two
for 1000th message). The cores on the DB server looked to
average around 45%/30% usage during delivery.
MySQL 4.1 is already very old. And MySQL 5.0 is much more faster then 4.1.
Do you think, you can test with MySQL 5.0 again? You can donwload ready to
go packages from mysql.com.
Agreed, PG 8.1.4 is about a year old and was the most recent release
until yesterday when 8.2 came out, so we probably aren't comparing
apples to apples with that old of a MySQL version. But while you are at
it, any chance you can run PG 8.2 through the same test?
On the other side, it would be more interesting for me, how fast we can
read from the databases. Inserting messages is not something which needs to
be fast. It's more interesting for me how fast we can read messages from
the imap server.
Agreed also, I think this is where most of the load comes from using
DBMail especially IMAP, so this would be the more compelling bench mark.
Matt
