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 <[email protected]> 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.
