[Rt-devel] RT 3.4 / Postgres / Search UI performance

[David Kerry]

On Thu, Jan 13, 2005 at 11:38:14PM -0500, Jesse Vincent wrote:
> 
> I've spent the evening doing some stress testing / performance work on
> RT 3.4's search page under postgres. I have a proposed patch, but I
> really need folks to beat on it to see if it improves things
> significantly and whether it seems to actually do the right thing.
> 
> It's attached to this message. If folks see a speed boost without 
> errors, it'll make it into 3.4.0. But this means taht I need sites
> running postgres (and other databases) to test it out. It's likey that
> the issue in question only manifests with a large number of queues. 

Wow... huge improvement here.  20+ seconds to bring up this
one page is now down to around 2 seconds.

This patch gets my vote of approval :-)

For what it's worth, we have 18 queues defined, which explains why
the situation was so bad for us.

-- 
David Kerry