[rt-users] RT 4 Upgrade Slow Performance

[Nathan Baker]

Hello Everyone,

We've upgraded from RT 3.8.8 with MySQL to RT 4.0.5 (debian package) with
Postgresql, and are having some performance issues with the web interface.
 I've searched the list archives and Google, and haven't been able to find
the issue.  I'm hoping someone can help point me in the right direction.
 Basically, the first time I visit any page (Home, Display, etc.) it takes
3-5 seconds to load, and sometimes 10-15 seconds.  If I keep clicking on
other links as soon as the pages load, it's fast and loads pages in 0.2 -
0.3 seconds.  If I wait for about 15-30 seconds and then click a link
again, it takes 3-5 seconds to load again.  Updating tickets seems to
consistently take 3-5 seconds.

Here's some info about our installation:
- About 6,000 tickets, 5 active users
- Increased memory to 2GB, running on VMWare
- Increased Postgresql shared_buffers and effective_cache_size (
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server)
- Changed JS Minifier to jsmin as suggested here:
http://www.gossamer-threads.com/lists/rt/users/102703

Our config seems fairly basic compared so some examples I've seen, I can
post it if necessary though.  We are using FullTextSearch and
CommandByMail, although I've tried disabling them both.  I turned on
debugging to a log file, and I don't see anything unusual.  I also turned
on the SQL statement log, and didn't see any queries taking a long time.
 The longest was 0.12 seconds.  I tried disabling the Javascript Minifier
in JS.pm like I've seen in other posts, and that didn't seem to make a
difference.

Any help would be greatly appreciated.

Thanks,
Nate
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120529/98195d57/attachment.htm>