> > The problem with PostgreSQL are missing transactions in dbmail. > > Because of that AutoCommit is used leading to 11 single transactions > > because of one inserted message. > > Very very true. If we implemented transactions for at least message > delivery (for begginers), we'd get a huge performance increase in > Postgres.
Yes, 1 instead of 11 transactions will speed up everything a LOT and we'll wonder if our load graphs are still working ... [.. apps developed for MySQL ..] Yes absolutely right. > Our plans are to put all of our money into a fault-tolerant heavy > database server What about putting parts of the money into dbmail development :-) Transactions and separating body and header (for imap) will be major improvements and probably cheaper than an appropriate db server. Thomas -- http://www.tmueller.com for pgp key (95702B3B)
