Latency when creating/updating tickets

When I first starting using RT last year,
creating/updating tickets was quick. Now, when
creating or updating an existing ticket, RT takes
about a minute to complete the task. However,
viewing/searching tickets is instant. I currently
have about 100 tickets in my database, and this
latency has slowly been getting worse. I’m using
postgres, and it runs on the same system as RT. If I
run ‘top’ during the latency, I see no processes
taking any significant CPU.

My system is a P500, 256M, RH6.2, kernel 2.2.12-20.
PostgreSQL 7.1.3, rt.2.0.5_03

Any tips, tweeks, or patch updates that might fix?

Thanks!

Do You Yahoo!?
Try FREE Yahoo! Mail - the world’s greatest free email!
http://mail.yahoo.com/

|+ My system is a P500, 256M, RH6.2, kernel 2.2.12-20.
|+ PostgreSQL 7.1.3, rt.2.0.5_03
|+
|+ Any tips, tweeks, or patch updates that might fix?

You may want to try upgrading versions of RT. RT added postgres speed
increases somewhere after I believe 2.0.9.

If you upgrade, you’ll probably want to recreate the databases with the new
schema (with new indexes, etc). Make sure to backup your database before
deleting it, and starting again :slight_smile:

-darrin