[rt-users] Large rt install is slow

Vivek Khera vivek at khera.org
Mon Nov 13 15:05:18 EST 2006


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
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2530 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20061113/bebb69c3/attachment.bin>


More information about the rt-users mailing list