Hi,
we have a debian lenny server running postgresql 8.3, php 5 and moodle 1.9.5. We have a mail server running cyrus-imapd adjacent to it. For various reasons, we installed roundcube on the moodle server to be a front-end to the cyrus imapd on the other server.
We're currently running roundcube v0.2.2 which is using the existing postgresql as its database. That database was originally created against roundcube v1-2 and I've had to upgrade it, somewhat manually as there didn't seem to be a script that could do it. We're running imapproxy on the roundcube server to try and speed things up.
I have just over 3500 emails in my mailbox. That's quite a few, but it's not massive. When I login to roundcube it takes a full minute to show me the mailbox (I have it set to display the most recent 100 mails). Every time I click for the next page of 100 mails, I wait at least another minute before it's displayed. During this time, Postgresql runs at moreorless 100% the entire time. This is just not usable. By contrast, when I login to ilohamail, I see the first 20 mails in 2 seconds.
It's possible that our manual upgrade has missed an index somewhere and as a result postgresql is having to work unduly hard. Does anyone have any suggestions for what I might do to work out what the hold up is?
Any other suggestions? Surely Roundcube isn't really this slow? Perhaps there's a bottleneck I just need to work out and all will be better?
Gavin
List info: http://lists.roundcube.net/users/