Large rt install is slow

RT Users
1

We have a large rt3.4 install of about 70K tickets and
growing. The larger the db grows, the slower it gets to the
point that its getting painful. We have it running on
postgresql7.4 on a dual proc system with 4GB of ram. The db
dump itself is only about 700MB.

Ive optimized the db to squeeze all the performance out of
it as possible, is there anything else that can be done? It
seems that it comes down to rt just making a lot of queries.
Most queries are down to a couple milliseconds, with a few
spiking to half a second. I’m not a dba by far, but is
there anything I can do to get rt to perform better? Thanks.

Scott Henson
LCSEE Systems Staff
WVU MAE Undergraduate
Ubuntu User

2

try my revised indexes posted here before several times. the indexes
shipped with RT are mostly unused by the queries generated by the
query builder.On Nov 10, 2006, at 4:50 PM, Scott J. Henson wrote:

We have a large rt3.4 install of about 70K tickets and
growing. The larger the db grows, the slower it gets to the
point that its getting painful. We have it running on
postgresql7.4 on a dual proc system with 4GB of ram. The db
dump itself is only about 700MB.

Ive optimized the db to squeeze all the performance out of
it as possible, is there anything else that can be done? It
seems that it comes down to rt just making a lot of queries.
Most queries are down to a couple milliseconds, with a few
spiking to half a second. I’m not a dba by far, but is
there anything I can do to get rt to perform better? Thanks.

–
Scott Henson
LCSEE Systems Staff
WVU MAE Undergraduate
Ubuntu User

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

smime.p7s (2.47 KB)

3

Vivek Khera wrote:

try my revised indexes posted here before several times. the indexes
shipped with RT are mostly unused by the queries generated by the query
builder.

Thanks for the reply. We just tried out rt3.6 and pg8.1 and
they seem to satisfy our performance needs. I’ll have a
look at those revised indexes, cause as we all know, every
bit of speed helps.

Scott Henson
LCSEE Systems Staff
WVU MAE Undergraduate
Ubuntu User