Thomas Mueller wrote:
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.
This is one of the things I/We want to address real soon. I've done some
small scale tests. Mostly to see if it works after having done only some
simple changes, and if failure conditions (non-existant user etc) were
handled gracefully.
I've done this only for message delivery, but it worked very nicely. I
haven't been able to do any load testing with it, so I can't say if it
performs any better.
Ilja
--
Ilja Booij
IC&S B.V.
Stadhouderslaan 57
3583 JD Utrecht
www.ic-s.nl
T algemeen: 030 6355730
T direct: 030 6355739
F: 030 6355731
E: [EMAIL PROTECTED]
