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

[Jesse Vincent]

On Fri, Jan 14, 2005 at 11:22:56AM -0500, David Kerry wrote:
> 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.

Is the list of possible owners _correct_?

	J

> 
> 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
> 

--