[rt-users] Re: Does Postgres offer acceptable performance

[Senoner Samuel]

I also use postgres on two servers. One is a P3 933 and one is a P3 499.
The faster machine has a relatively low usage (10 tickets a day) and the
other a bit more users and requests (50 tickets a day). The software
configuration of both systems is identical. The 933 machine has a really
good performance, with no problems on working on RT. The second has an
unacceptable performance, but the machine is slow.... Not only because
of the processor...... 

Anyway it also depends with wich version of RT you are working (there
have been many improvements for postgres in the last releases for what I
could read) and also how you set up the rest of your box...... But also
from the ticket. Yesterday I read that it depends if there are big
attachments in the ticket (I saw it in the late afternoon also on my
box) it takes longer to load it.

Samuel

-----Original Message-----
From: Andrew J. Korty [mailto:ajk at iu.edu] 
Sent: Thursday,11 December,2003 14:34
To: rt-users at lists.fsck.com
Subject: [rt-users] Re: Does Postgres offer acceptable performance

Richard Gration <richard at zync.co.uk> writes:

> On Thursday 11 December 2003 12:29, Andrew J. Korty wrote:
>
>> I'm a long-time PostgreSQL user, but it was intolerably slow with a 
>> 30,000-ticket RT database.  Even after a *lot* of tuning (server 
>> parameters, custom indexes, etc.), certain queries, especially large 
>> joins, took minutes to complete.  Other folks seem to have no 
>> problems, though, so maybe I missed something.
>
> At the risk of stating the obvious (a subject which all English people

> have a doctorate in ;-) ), how long has it been since you did a 
> "vacuum analyze" on your rt db? I have seen this simple operation cut 
> down the time for big joins from a couple of minutes to a couple of 
> seconds!!

I was doing "vacuum analyze" several times a day, and it did improve
performance.  It just didn't improve it enough. :-)

--
Andrew J. Korty, Principal Security Engineer, GCIA, GCFA Office of the
Vice President for Information Technology Indiana University

_______________________________________________
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