Slow performance - 4.0.4 with PostgreSQL installed from Ubuntu 12.04 packages

We’re running RT 4.0.4 on PostgreSQL, both installed from the Ubuntu 12.04 repository.

It’s working just fine, but the performance is poor. Updating tickets with comments or replies is particularly slow. Read-performance seems to be fine, only making changes is slow.

Historically, we’ve run RT 3.6.5 on MySQL, and initially this had poor performance because of missing indexes. Our new RT 4 install is a fresh installation - not an upgrade, with a new database. Are there any known missing indexes on RT+PostgreSQL when installing from the Ubuntu packages?

If not, what’s the best way to start diagnosing what’s eating up the most time?

David X. Glover
IT Support, Physics
University of Oxford

Hi,

Start from logs: SQL log and RT log. Timestamps in RT logs on debug
level can give you idea.On Mon, May 28, 2012 at 5:15 PM, David X. Glover dxg@physics.ox.ac.uk wrote:

We’re running RT 4.0.4 on PostgreSQL, both installed from the Ubuntu 12.04 repository.

It’s working just fine, but the performance is poor. Updating tickets with comments or replies is particularly slow. Read-performance seems to be fine, only making changes is slow.

Historically, we’ve run RT 3.6.5 on MySQL, and initially this had poor performance because of missing indexes. Our new RT 4 install is a fresh installation - not an upgrade, with a new database. Are there any known missing indexes on RT+PostgreSQL when installing from the Ubuntu packages?

If not, what’s the best way to start diagnosing what’s eating up the most time?


David X. Glover
IT Support, Physics
University of Oxford

Best regards, Ruslan.

Start from logs: SQL log and RT log. Timestamps in RT logs on debug
level can give you idea.

Good tip. I’ve pinned down the problem to being only when mail is sent, which would imply exim is somehow being slow…

David X. Glover
IT Support, Physics
University of Oxford

Start from logs: SQL log and RT log. Timestamps in RT logs on debug
level can give you idea.

Good tip. I’ve pinned down the problem to being only when mail is sent, which would imply exim is somehow being slow…

This is what I have suspected.

http://requesttracker.wikia.com/wiki/SendmailTips

Basicly you want exim to queue mail and don’t want it do any checks
when RT calls sendmail program.


David X. Glover
IT Support, Physics
University of Oxford

Best regards, Ruslan.