[rt-users] How to improve performance ?

Vivek Khera vivek at khera.org
Mon Mar 7 16:56:30 EST 2005


On Mar 3, 2005, at 8:29 AM, Andre Sachs wrote:

> We have indexed the tables but no appreciable speed up has been 
> witnessed.
>

after you "analyze" your tables, what does "explain" have to say about 
your above queries?

I posted here a while back some alternative indexes for RT 3.2 based on 
my experiences.  There are a few indexes that are totally unused which 
just add disk I/O during updates/inserts that are wasted.

Vivek Khera, Ph.D.
+1-301-869-4449 x806




More information about the rt-users mailing list