You really want to try RT-3.4.5. I'm not Pg guru, but there is thread on the list that is related to performance on Pg 7.x vs. 8.0.x. Find it, it should be really useful.
On 4/19/06, Jörg Ungermann <[EMAIL PROTECTED]> wrote: > Dear Sirs, > > we do run RT 3.4.2 on Debian Sarge and Postgres 8 > > We do have 20 users and 2500 Tickets at the moment. > There have been performance issues ever since, but we blaimed them on the > shared server. > There shell be 10 new users in nnear future. > > Now we moved to a brand new PC Server with contemporary hardware (it is > powerfull). > Still opening ticktes, replying or creating tickets takes sometimes 10- 20 > seconds. > > I have scanned the RT Lists and found some hinds. > Since we are under pressure i would apreciate if someone has mastered these > problems and can give guidance what is to be done. What is most promising to > concentrate on (database, Perl, DBI::Search? > > Please help us make our RT the lean fast and handy tool we need it to be! > > I attach the system report for an overview to libraries etc. [snip] -- Best regards, Ruslan.
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html