[rt-users] RT freezes on some big tickets

[The Anarcat]

On Tue, Mar 11, 2008 at 07:45:24AM -0500, Kenneth Marshall wrote:
> Welcome to the world of stateless page loads. :)

Whee! :)

> The only suggestions
> that I have are in two areas. Can you modify the page load to skip the
> un-interesting transactions/attachments?

er... sure i'd like to!

> We had to do that here with
> system events (not attachments) and added a brief/full button on the
> history. The default is only needed information and then if you select
> "full" you get everything which may require a wait.

How did you go around doing that?

> The second area
> is database monitoring. Have you identified the queries that are running?
> Are they optimized? Would clustering your attachments improve retrieval
> performance? Good luck.

This being a production server, running tracing on the postgresql
database imposes major load, so no, I haven't looked at the queries,
even less optimize them...

How can I go around clustering the attachments?

Thanks for the input.

A.

-- 
If builders built houses the way programmers built programs,
The first woodpecker to come along would destroy civilization.
                        - Gerald Weinberg
-------------- 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/20080311/de9912a9/attachment.sig>