[rt-users] Re: [rt-devel] DBIx-SearchBuilder 0.81 released

[Jesse Vincent]

There's really no need to crosspost something like this to both rt-users
and rt-devel.  Can you tell us _what_ postgres queries it's bogging down
on. Have you done a vacuum and analyze since you did your RT2 import? 
If not, the query optimizer won't have any idea what's going on and
you'll get extremely slow performance.

	-j




On Fri, May 02, 2003 at 01:56:04PM +0200, Phil Regnauld wrote:
> Jesse Vincent (jesse) writes:
> > This version is exactly the same as 0.81_04. It contains changes to
> > massively improve performance when using postgresql for complex selects.
> 
> 	Hi Jesse,
> 
> 	I'm testing here 3.0.2pre4 with 0.81_04, and I'm observing _very_
> 	long query times and heavy CPU usage from PgSQL.  It's a 7.3.2 PgSQL
> 	running on a 550 MHz PIII, with FastCGI.
> 
> 	When I mean heavy, something like 8-10 seconds with PgSQL at 50-60%
> 	CPU to be able to reply to a ticket (albeit one from a dataset migrated
> 	from RT2) via the web interface.
> 
> 	Phil
> 
> -- 
>   _ _ |_ | regnauld at catpipe.net                   catpipe Systems ApS   |
>  (_(_||_ |          *BSD solutions, consulting, development             |
>          | Tlf.: +45 7021 0050                  http://www.catpipe.net/ |

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.