On Thu, 27 Aug 2009, chasd wrote: > I use PostgreSQL and do not have performance issues, although I don't > have thousands of messages in any mailboxes.
I'm afraid lots of our users do. > I have turned off message caching because it did not increase > performance, although I'm not using the latest RC. That seems to have improved us very substantially. This is v0.2.2 so perhaps the RC would be better. > ( IMHO, message caching should be done via HTML 5 local storage, but > that's off topic ) It certainly seems excessive for us to use imaproxyd _and_ postgresql for caching. > Also, when I upgrade I drop the existing database and create a new, > fresh DB. > Yeah, this loses some data, but RC isn't the primary access to our > user's e-mail, it is for remote use only. This really isn't acceptable for us. I may just try and transfer the identities and contacts back over. > cyrus might also be something to look at. > Many on the RC users list have mentioned that dovecot was faster when > they switched from other IMAP servers. Cyrus' performance is pretty good, as evidenced by IlohaMail's speed on the same server. If cyrus were that slow, every instance of thunderbird and outlook would be slow too and I wouldn't expect the 100% cpu from postgresql. I'd say it's definitely a database access bottleneck and turning off the caching seems to sort it out. > Yeah, and cyrus has features dovecot doesn't have. It certainly used to, though I get the impression dovecot has developed quite a bit in recent years. Gavin _______________________________________________ List info: http://lists.roundcube.net/users/
