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

[Paul Wagland]

And more importantly :-) (Given that this is the request that people are
saying is really slow)

This is also from ab:

old:
----
Document Path:          /rt3/Ticket/Update.html?Action=Respond&id=1003
Document Length:        9261 bytes

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

Percentage of the requests served within a certain time (ms)
  50%  10529
  66%  10687
  75%  10822
  80%  11066
  90%  11943


new:
----
Document Path:          /rt3/Ticket/Update.html?Action=Respond&id=1003
Document Length:        9261 bytes

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

Percentage of the requests served within a certain time (ms)
  50%    796
  66%    827
  75%    848
  80%    891
  90%   1018


BTW, just in case anyone out there is using the Debian packages and wants to
install this, here are the steps required:
mkdir -p /usr/local/share/request-tracker3/lib/RT/
cp Groups_Local.pm Users_Local.pm \
	/usr/local/share/request-tracker3/lib/RT/
mkdir -p /usr/local/share/request-tracker3/html/Elements/
cp SelectOwner.dat \
	/usr/local/share/request-tracker3/html/Elements/SelectOwner

For the standard RT install you need to do something similar, but I am not
sure what the exact directories are.

BTW (if you are reading this) Thanks to Andrew Stribblehill for the Debian
packages! They have made my life so much easier!

I hope this helps,

Cheers,
Paul

> -----Original Message-----
> From: Paul Wagland [mailto:pwagland at allshare.nl]
> Sent: Friday, June 27, 2003 14:30
> To: Val Luck; rt-users at lists.fsck.com
> Subject: RE: [rt-users] performance problem - RT3.0.3 on Postgresql
> 7.3.3
>
>
> 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
> >
> >