> I have used DbMail on both pgsql and mysql with much the same results > except as the user numbers grow mysql begins to outperform pgsql in > speed. That could be me. I am not as adept with PostgreSQL. One thing is > for sure, whatever lags there may be, pgsql always holds up and all > queues are finished. I have dumped MySQL cores a few times on account of > my test code errors and loops but not PostgreSQL. It tolerates my wicked > tests -- just makes me wait. MySQL dumps. Go figure.
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. Thomas -- http://www.tmueller.com for pgp key (95702B3B)
