[rt-devel] Postgres performance.

Jesse Vincent jesse at bestpractical.com
Wed Apr 2 10:14:03 EST 2003



On Wed, Apr 02, 2003 at 07:51:39PM +0930, Aidan Mountford wrote:
> Hello all,
> 
> I am using RT with a pg backend.
> 
> I am having some fairly serious issues relating to the performance of some
> of the queries built by the query builder.
> 
> The worst issues seem to appear from an ACL lookup that occurs when
> responding/commenting.
> 
> I have captured this query and note that it is not using joins.
> 
> To prove the point, i manually optimised this query, and reduced the
> execution time from almost a  minute down to about 4 seconds.

Can you show us the unoptimized and optimized queries?


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



More information about the Rt-devel mailing list