[rt-users] Large rt install is slow

[Vivek Khera]

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>