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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
