[rt-users] performance problem - RT3.0.3 on Postgresql 7.3.3

[Paul Wagland]

Hi all,

Just to add another data point in here....

We are using Debian, Postgres 7.3.3 and RT 3.0.3 (and all of it's
dependencies :-)

If you are in this setup I would suggest that you try the patch that
Christopher Audley wrote and sent to the devel list:
> Sent: Wednesday, June 25, 2003 20:46
> Subject: [rt-devel] Users::WhoHaveRight and Sybase

Using this patch gave us the following results:
Well, I have tested this and have come up with the following results (all
times are averaged over ten runs):

Page					before time		after time
Ticket/Create.html		13.6			0.4
Ticket/ModifyPeople.html	9.5			0.6
Search/Bulk.html			~4			~2

Using the ab tool from Apache gave these results:

old
---
Document Path:          /rt3/Ticket/ModifyPeople.html?id=1502
Document Length:        9951 bytes

Concurrency Level:      1
Time taken for tests:   299.844 seconds
Complete requests:      20

Percentage of the requests served within a certain time (ms)
  50%  13132
  66%  15160
  75%  18217
  80%  18981
  90%  24829
  95%  24829



new
---
Document Path:          /rt3/Ticket/ModifyPeople.html?id=1502
Document Length:        9951 bytes

Concurrency Level:      1
Time taken for tests:   16.553 seconds
Complete requests:      20

Percentage of the requests served within a certain time (ms)
  50%    668
  66%    677
  75%    689
  80%    720
  90%   1497
  95%   1497


As you can see... A distinct improvement!

Hope this helps you all,
Cheers,
Paul

> -----Original Message-----
> From: rt-users-admin at lists.fsck.com
> [mailto:rt-users-admin at lists.fsck.com]On Behalf Of Val Luck
> Sent: Friday, June 27, 2003 3:46
> To: rt-users at lists.fsck.com
> Subject: RE: [rt-users] performance problem - RT3.0.3 on Postgresql
> 7.3.3
>
>
>
> Hello RT users,
>
> Just to add another data point, I am using rt-3-0-2 and
> postgresql-7.3.2 on Red Hat 8, and I am having the exact same
> issues with Reply/Resolve/Comment.  We have a relatively new
> install of and not a lot of tickets, and it can take 60-70
> seconds when clicking on Reply/Resolve/Comment.
>
> I'd love to know any performance tweaks that could be done to Red
> Hat, RT or PostgreSql...?
>
> Val
>
>
> -----Original Message-----
> From: Sophie Rockhsar [mailto:sophia at aps.org]
> Sent: Thursday, June 26, 2003 12:28 PM
> To: rt-users at lists.fsck.com
> Subject: [rt-users] performance problem - RT3.0.3 on Postgresql 7.3.3
>
>
> Hi all,
>
> Just upgraded to RT 3.0.3, on PostgreSql 7.3.3 (FreeBSD 4.8 box).
> The database
> had already existed (and had RT 3.0.2 running on it), so I just got the
> upgrade through the ports collection, and left the existing
> database intact.
> I restarted the postgres server and apache, and that was all...
>
> The performance of the database server is extremely bad when any
> Reply/Resolve/Comment is issued on a ticket. Any suggestions?
>
> Thanks much,
> Sophie
> _______________________________________________
> 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
> _______________________________________________
> 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
>
>