[rt-users] RT freezes on some big tickets

[The Anarcat]

Hi,

We're having growing problems with tickets with a long history and lots
of comments/correspondance. When visiting certain looong tickets, RT
will take up to 2-3 minutes actually rendering the pages.

Here's what top says about this:

  PID USERNAME       THR PRI NICE   SIZE    RES STATE  C   TIME   WCPU COMMAND
25455 www              1 105    0 73424K 70184K CPU1   1   1:21 58.54% perl5.8.8
  796 pgsql            1  96    0  8644K  3368K select 0  67:13 10.74% postgres

Nothing in the error.log.

Of course, when *I* try to debug this, RT actually behaves /okay/ in
that it renders the page and doesn't crash, but it does slow down the
server as hell. Which means that when *others* stumble on this ticket,
they figure the thing is stuck and hit reload repeatedly, of which you
can imagine the disastrous results...

This is:

FreeBSD lethe.koumbit.net 6.2-RELEASE-p2 FreeBSD 6.2-RELEASE-p2 #0: Fri Mar  9 14:54:27 EST 2007

RT 3.6.6 on PostgreSQL 8.2.3.

The particular ticket here has 516 transactions associated to it,
according to postgresql and around 50-60 attachments (half of which are
PGP-MIME signatures).

-- 
Never underestimate the bandwidth of a station wagon full of tapes
hurtling down the highway.
                        - Andrew S. Tanenbaum, "Computer Networks"
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080310/376bd7e0/attachment.sig>