ruz at bestpractical
May 28, 2012, 8:05 AM
Post #2 of 4
Re: Slow performance - 4.0.4 with PostgreSQL installed from Ubuntu 12.04 packages
[In reply to]
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 [at] physics> 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.