[rt-users] crazy sql during "reply" action

[Jesse Vincent]

Can you tell me exactly what query it was stuck on? 13 minutes on a
query really sounds like your system must be thrashing to hell and back.
Is the machine swapping heavily?


On Mon, Apr 14, 2003 at 02:59:34PM +1000, Jamie Wilkinson wrote:
> This one time, at band camp, Jesse Vincent wrote:
> >You may want to follow the ongoing discussion of this issue on rt-devel.
> >It's a known problem and it's being worked on.
> 
> I've just installed DBIx::SearchBuilder 0.81_02.  I can't see any noticeable
> improvement in speed.
> 
> I ran vacuum full just before attempting the query.  It took 15 almost
> exactly 15 minutes from the moment I clicked "Reply" until the page had
> finished loading.  Postgres took about 13:53 in cpu time to complete the
> query.
> 
> -- 
> jaq at spacepants.org                           http://spacepants.org/jaq.gpg
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

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