Serious performance problems

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.

##Start system report##
Perl v5.8.8 under linux
Apache v1.27;
Apache::Connection v1.00;
Apache::Constants v1.09;
Apache::DBI v0.94;
Apache::Request v1.33;
Apache::Server v1.01;
Apache::Session v1.80;
Apache::Session::Generate::MD5 v2.1;
Apache::Session::lock::Null v1.01;
Apache::Session::Postgres v1.01;
Apache::Session::Serialize::Base64 v1.00;
Apache::Session::Store::DBI v1.02;
Apache::Session::Store::Postgres v1.03;
Apache::Status v2.03;
Apache::Symbol v1.31;
Apache::Table v0.01;
AutoLoader v5.60;
B v1.09_01;
base v2.07;
Benchmark v1.07;
bytes v1.02;
Cache::Simple::TimedExpiry v0.21;
Carp v1.04;
CGI v3.15;
CGI::Cookie v1.26;
CGI::Util v1.5;
Class::Container v0.12;
Class::Data::Inheritable v0.04;
Class::ReturnValue v0.53;
Clone v0.18;
constant v1.05;
Cwd v3.12;
Data::Dumper v2.121_08;
DBD::Pg v1.45;
DBD::Sponge v11.10;
DBI v1.50;
DBIx::SearchBuilder v1.39;
DBIx::SearchBuilder::Unique v0.01;
Devel::StackTrace v1.11;
Devel::StackTraceFrame v0.6;
Devel::Symdump v2.03;
Digest::base v1.00;
Digest::MD5 v2.36;
DynaLoader v1.04;
Encode v2.12;
Encode::Alias v2.04;
Encode::Config v2.01;
Encode::Encoding v2.02;
Errno v1.0901;
Exception::Class v1.21;
Exception::Class::Base v1.2;
Exporter v5.58;
Exporter::Heavy v5.58;
Fcntl v1.05;
fields v2.03;
File::Basename v2.74;
File::Glob v1.05;
File::Path v1.08;
File::Spec v3.12;
File::Spec::Unix v1.5;
File::Temp v0.16;
FileHandle v2.01;
HTML::Entities v1.35;
HTML::Mason v1.32;
HTML::Mason::ApacheHandler v1.69;
HTML::Mason::Exception v1.1;
HTML::Mason::Exception::Abort v1.1;
HTML::Mason::Exception::Compilation v1.1;
HTML::Mason::Exception::Compilation::IncompatibleCompiler v1.1;
HTML::Mason::Exception::Compiler v1.1;
HTML::Mason::Exception::Decline v1.1;
HTML::Mason::Exception::Params v1.1;
HTML::Mason::Exception::Syntax v1.1;
HTML::Mason::Exception::System v1.1;
HTML::Mason::Exception::TopLevelNotFound v1.1;
HTML::Mason::Exception::VirtualMethod v1.1;
HTML::Mason::Exceptions v1.43;
HTML::Parser v3.51;
HTML::Scrubber v0.08;
I18N::LangTags v0.35;
I18N::LangTags::Detect v1.03;
integer v1.00;
IO v1.22;
IO::File v1.13;
IO::Handle v1.25;
IO::InnerFile v2.110;
IO::Lines v2.110;
IO::Scalar v2.110;
IO::ScalarArray v2.110;
IO::Seekable v1.1;
IO::Wrap v2.110;
IO::WrapTie v2.110;
IPC::Open2 v1.02;
IPC::Open3 v1.02;
lib v0.5565;
List::Util v1.18;
Locale::Maketext v1.09;
Locale::Maketext::Fuzzy v0.02;
Locale::Maketext::Lexicon v0.53;
Locale::Maketext::Lexicon::Gettext v0.14;
Log::Dispatch v2.11;
Log::Dispatch::Base v1.09;
Log::Dispatch::Output v1.26;
Log::Dispatch::Screen v1.17;
Log::Dispatch::Syslog v1.18;
Mail::Address v1.74;
Mail::Field v1.74;
Mail::Field::AddrList v1.74;
Mail::Field::Date v1.74;
Mail::Header v1.74;
Mail::Internet v1.74;
MIME::Base64 v3.07;
MIME::Body v5.419;
MIME::Decoder v5.419;
MIME::Decoder::NBit v5.419;
MIME::Entity v5.419;
MIME::Field::ContDisp v5.419;
MIME::Field::ConTraEnc v5.419;
MIME::Field::ContType v5.419;
MIME::Field::ParamVal v5.419;
MIME::Head v5.419;
MIME::Parser v5.419;
MIME::QuotedPrint v3.07;
MIME::Tools v5.419;
MIME::Words v5.419;
mod_perl v1.29;
Module::Versions::Report v1.02;
overload v1.04;
Params::Validate v0.77;
POSIX v1.09;
re v0.05;
Regexp::Common v2.120;
Regexp::Common::_support v2.101;
Regexp::Common::balanced v2.101;
Regexp::Common::CC v2.100;
Regexp::Common::comment v2.116;
Regexp::Common::delimited v2.104;
Regexp::Common::lingua v2.105;
Regexp::Common::list v2.103;
Regexp::Common::net v2.105;
Regexp::Common::number v2.108;
Regexp::Common::profanity v2.104;
Regexp::Common::SEN v2.102;
Regexp::Common::URI v2.108;
Regexp::Common::URI::fax v2.100;
Regexp::Common::URI::file v2.100;
Regexp::Common::URI::ftp v2.101;
Regexp::Common::URI::gopher v2.100;
Regexp::Common::URI::http v2.101;
Regexp::Common::URI::news v2.100;
Regexp::Common::URI::pop v2.100;
Regexp::Common::URI::prospero v2.100;
Regexp::Common::URI::RFC1035 v2.100;
Regexp::Common::URI::RFC1738 v2.104;
Regexp::Common::URI::RFC1808 v2.100;
Regexp::Common::URI::RFC2384 v2.102;
Regexp::Common::URI::RFC2396 v2.100;
Regexp::Common::URI::RFC2806 v2.100;
Regexp::Common::URI::tel v2.100;
Regexp::Common::URI::telnet v2.100;
Regexp::Common::URI::tv v2.100;
Regexp::Common::URI::wais v2.100;
Regexp::Common::whitespace v2.103;
Regexp::Common::zip v2.112;
RT v3.4.2;
RT::Interface::Email v1.02;
Scalar::Util v1.18;
SelectSaver v1.01;
Socket v1.78;
Storable v2.15;
strict v1.03;
Symbol v1.06;
Sys::Syslog v0.13;
Text::Autoformat v1.13;
Text::Quoted v1.8;
Text::Reform v1.11;
Text::Tabs v2005.0824;
Text::Template v1.44;
Text::Wrapper v1.000;
Time::HiRes v1.86;
Time::JulianDay v2003.1125;
Time::Local v1.11;
Time::ParseDate v2003.1126;
Time::Timezone v2003.0211;
Time::Zone v2.22;
URI v1.35;
URI::Escape v3.28;
URI::URL v5.03;
URI::WithBase v2.19;
utf8 v1.06;
vars v1.01;
Want v0.09;
warnings v1.05;
warnings::register v1.01;
XSLoader v0.06;

RT Variablen
RT::AmbiguousDayInPast 1
RT::BasePath /usr/share/request-tracker3.4
RT::BinPath /usr/bin
RT::CORE_CONFIG_FILE /etc/request-tracker3.4/RT_Config.pm
RT::CommentAddress rt-comment@localhost
RT::CorrespondAddress rt@localhost
RT::DatabaseHost localhost
RT::DatabaseName Request-Tracker
RT::DatabasePassword Password not printed
RT::DatabaseRTHost localhost
RT::DatabaseType Pg
RT::DatabaseUser rtuser
RT::DateDayBeforeMonth 1
RT::DefaultSearchResultFormat ‘id/TITLE:#’, ‘Subject/TITLE:Subject’, Status, QueueName, OwnerName, Priority, ‘NEWLINE’, ‘’, ‘Requestors’, ‘CreatedRelative’, ‘ToldRelative’, ‘LastUpdatedRelative’, ‘TimeLeft
RT::EmailOutputEncoding utf-8
RT::EtcPath /etc/request-tracker3.4
RT::FriendlyFromLineFormat “%s via RT” <%s>
RT::FriendlyToLineFormat “%s of DBD - Troubleticketing Ticket #%s”:;
RT::LocalEtcPath /usr/local/share/request-tracker3.4/etc
RT::LocalLexiconPath /usr/local/share/request-tracker3.4/po
RT::LocalPath /usr/local/share/request-tracker3.4
RT::LogDir /var/log/request-tracker3.4
RT::LogToFileNamed rt.log
RT::LogToScreen error
RT::LogToSyslog debug
RT::LogoURL /RT/NoAuth/images/bplogo.gif
RT::LoopsToRTOwner 1
RT::MailCommand sendmailpipe
RT::MasonComponentRoot /usr/share/request-tracker3.4/html
RT::MasonDataDir /var/cache/request-tracker3.4/mason_data
RT::MasonLocalComponentRoot /usr/local/share/request-tracker3.4/html
RT::MasonSessionDir /var/cache/request-tracker3.4/session_data
RT::MaxAttachmentSize 10000000
RT::MaxInlineBody 13456
RT::MessageBoxWidth 72
RT::MessageBoxWrap HARD
RT::MinimumPasswordLength 5
RT::MyRequestsLength 10
RT::MyTicketsLength 10
RT::Organization DBD
RT::OwnerEmail root
RT::RTAddressRegexp ^rt@example.com$
RT::RecordOutgoingEmail 1
RT::RedistributeAutoGeneratedMessages 1
RT::SITE_CONFIG_FILE /etc/request-tracker3.4/RT_SiteConfig.pm
RT::SendmailArguments -oi -t
RT::SendmailPath /usr/sbin/sendmail
RT::Timezone Europe/London
RT::UseFriendlyFromLine 1
RT::VERSION 3.4.2
RT::VarPath /var/cache/request-tracker3.4
RT::WebBaseURL http://nagios
RT::WebFlushDbCacheEveryRequest 1
RT::WebImagesURL /RT/NoAuth/images/
RT::WebPath /RT
RT::WebURL http://nagios/RT/
RT::rtname DBD - Troubleticketing
Perl Konfiguration

Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
Platform:
osname=linux, osvers=2.6.15.4, archname=i486-linux-gnu-thread-multi
uname=‘linux ninsei 2.6.15.4 #1 smp preempt mon feb 20 09:48:53 pst 2006 i686 gnulinux ’
config_args=’-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN -Dcccdlflags=-fPIC -Darchname=i486-linux-gnu -Dprefix=/usr -Dprivlib=/usr/share/perl/5.8 -Darchlib=/usr/lib/perl/5.8 -Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5 -Dvendorarch=/usr/lib/perl5 -Dsiteprefix=/usr/local -Dsitelib=/usr/local/share/perl/5.8.8 -Dsitearch=/usr/local/lib/perl/5.8.8 -Dman1dir=/usr/share/man/man1 -Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1 -Dsiteman3dir=/usr/local/man/man3 -Dman1ext=1 -Dman3ext=3perl -Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Uusesfio -Uusenm -Duseshrplib -Dlibperl=libperl.so.5.8.8 -Dd_dosuid -des’
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define usemultiplicity=define
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc=‘cc’, ccflags =‘-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64’,
optimize=‘-O2’,
cppflags=‘-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include’
ccversion=‘’, gccversion=‘4.0.3 20060212 (prerelease) (Debian 4.0.2-9)’, gccosandvers=‘’
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype=‘long’, ivsize=4, nvtype=‘double’, nvsize=8, Off_t=‘off_t’, lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld=‘cc’, ldflags =’ -L/usr/local/lib’
libpth=/usr/local/lib /lib /usr/lib
libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
perllibs=-ldl -lm -lpthread -lc -lcrypt
libc=/lib/libc-2.3.6.so, so=so, useshrplib=true, libperl=libperl.so.5.8.8
gnulibc_version=‘2.3.6’
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=‘-Wl,-E’
cccdlflags=‘-fPIC’, lddlflags=‘-shared -L/usr/local/lib’
SMS schreiben mit WEB.DE FreeMail - einfach, schnell und
kostenguenstig. Jetzt gleich testen! WEB.DE - E-Mail-Adresse kostenlos, FreeMail, De-Mail & Nachrichten

We’re running 3.4.1 on Debain Sarge with Apache1,modperl & Mysql (all packages on this system are from stable) and response times are “realtime” - 15 user approx 5000 tickets
We had RT 3.0.12 before on the same box, also no problems.
I’ll post my config below, maybe it helps you to see a problem source (your versions look like being partially from sid)

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf
Of Jörg Ungermann
Sent: Wednesday, April 19, 2006 9:13 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Serious performance problems

Dear Sirs,

we do run RT 3.4.2 on Debian Sarge and Postgres 8
3.4.2 ? The latest package from sarge is 3.4.1, you should give it a try, it works like a charme away from apt-get install… At least if your problems don’t work out, I’d try to pull everything to stable…

Michael

— config –
Perl v5.8.4 under linux
Apache v1.27;
Apache::Connection v1.00;
Apache::Constants v1.09;
Apache::DBI v0.94;
Apache::Request v1.1;
Apache::Server v1.01;
Apache::Session v1.6;
Apache::Session::Generate::MD5 v2.1;
Apache::Session::lock::MySQL v1.00;
Apache::Session::MySQL v1.01;
Apache::Session::Serialize::Storable v1.00;
Apache::Session::Store::DBI v1.02;
Apache::Session::Store::MySQL v1.04;
Apache::Status v2.03;
Apache::Symbol v1.31;
Apache::Table v0.01;
AutoLoader v5.60;
B v1.02;
base v2.05;
Benchmark v1.06;
bytes v1.01;
Cache::Simple::TimedExpiry v0.21;
Carp v1.02;
CGI v3.04;
CGI::Cookie v1.24;
CGI::Util v1.4;
Class::Container v0.11;
Class::Data::Inheritable v0.02;
Class::ReturnValue v0.52;
constant v1.04;
Cwd v2.17;
Data::Dumper v2.121;
DBD::mysql v2.9006;
DBI v1.46;
DBIx::SearchBuilder v1.26;
Devel::StackTrace v1.11;
Devel::StackTraceFrame v0.6;
Devel::Symdump v2.03;
Digest::base v1.00;
Digest::MD5 v2.33;
DynaLoader v1.04;
Encode v1.99_01;
Encode::Alias v1.38;
Encode::Config v1.07;
Encode::Encoding v1.33;
Errno v1.09;
Exception::Class v1.20;
Exception::Class::Base v1.2;
Exporter v5.58;
Exporter::Heavy v5.58;
Fcntl v1.05;
fields v2.03;
File::Basename v2.72;
File::Glob v1.02;
File::Path v1.06;
File::Spec v0.87;
File::Spec::Unix v1.5;
File::Temp v0.14;
FileHandle v2.01;
HTML::Entities v1.29;
HTML::Mason v1.26;
HTML::Mason::ApacheHandler v1.69;
HTML::Mason::Exception v1.1;
HTML::Mason::Exception::Abort v1.1;
HTML::Mason::Exception::Compilation v1.1;
HTML::Mason::Exception::Compilation::IncompatibleCompiler v1.1;
HTML::Mason::Exception::Compiler v1.1;
HTML::Mason::Exception::Decline v1.1;
HTML::Mason::Exception::Params v1.1;
HTML::Mason::Exception::Syntax v1.1;
HTML::Mason::Exception::System v1.1;
HTML::Mason::Exception::TopLevelNotFound v1.1;
HTML::Mason::Exception::VirtualMethod v1.1;
HTML::Mason::Exceptions v1.43;
HTML::Parser v3.45;
HTML::Scrubber v0.08;
I18N::LangTags v0.29;
I18N::LangTags::List v0.29;
integer v1.00;
IO v1.21;
IO::File v1.10;
IO::Handle v1.24;
IO::InnerFile v2.110;
IO::Lines v2.110;
IO::Scalar v2.110;
IO::ScalarArray v2.110;
IO::Seekable v1.09;
IO::Wrap v2.110;
IO::WrapTie v2.110;
IPC::Open2 v1.01;
IPC::Open3 v1.0106;
lib v0.5565;
List::Util v1.13;
locale v1.00;
Locale::Maketext v1.08;
Locale::Maketext::Fuzzy v0.02;
Locale::Maketext::Lexicon v0.49;
Locale::Maketext::Lexicon::Gettext v0.14;
Log::Agent v0.306;
Log::Dispatch v2.10;
Log::Dispatch::Base v1.09;
Log::Dispatch::File v1.22;
Log::Dispatch::Output v1.26;
Log::Dispatch::Screen v1.17;
Log::Dispatch::Syslog v1.18;
Mail::Address v1.62;
Mail::Field v1.62;
Mail::Field::AddrList v1.62;
Mail::Field::Date v1.62;
Mail::Header v1.62;
Mail::Internet v1.62;
MIME::Base64 v3.04;
MIME::Body v5.417;
MIME::Decoder v5.417;
MIME::Entity v5.417;
MIME::Field::ContDisp v5.417;
MIME::Field::ConTraEnc v5.417;
MIME::Field::ContType v5.417;
MIME::Field::ParamVal v5.417;
MIME::Head v5.417;
MIME::Parser v5.417;
MIME::QuotedPrint v3.03;
MIME::Tools v5.417;
MIME::Words v5.417;
mod_perl v1.29;
Module::Versions::Report v1.02;
overload v1.01;
Params::Validate v0.76;
POSIX v1.08;
re v0.04;
Regexp::Common v2.120;
Regexp::Common::delimited v2.104;
RT v3.4.1;
RT::Interface::Email v1.02;
Scalar::Util v1.13;
SelectSaver v1.00;
Socket v1.77;
Storable v2.12;
strict v1.03;
Symbol v1.05;
Sys::Hostname v1.11;
Sys::Syslog v0.05;
Text::Autoformat v1.12;
Text::Quoted v1.8;
Text::Reform v1.11;
Text::Tabs v98.112801;
Text::Template v1.44;
Text::WikiFormat v0.71;
Text::Wrapper v1.000;
Time::HiRes v1.59;
Time::JulianDay v2003.1125;
Time::Local v1.07;
Time::ParseDate v2003.1126;
Time::Timezone v2003.0211;
Time::Zone v2.22;
URI v1.35;
URI::Escape v3.28;
utf8 v1.03;
vars v1.01;
warnings v1.03;
warnings::register v1.00;
XSLoader v0.02;

RT Variables
RT::BasePath /usr/share/request-tracker3.4
RT::BinPath /usr/bin
RT::CORE_CONFIG_FILE /etc/request-tracker3.4/RT_Config.pm
RT::CanonicalizeEmailAddressMatch elabx.xxx.de$
RT::CanonicalizeEmailAddressReplace xxx.de
RT::CommentAddress ssc-comment@xxx.de
RT::CorrespondAddress ssc@xxx.de
RT::DatabaseHost localhost
RT::DatabaseName rt34
RT::DatabasePassword Password not printed
RT::DatabaseRTHost localhost
RT::DatabaseType mysql
RT::DatabaseUser rt_user
RT::DateDayBeforeMonth 1
RT::DefaultSearchResultFormat ‘id/TITLE:#’, ‘Subject/TITLE:Subject’, Status, QueueName, OwnerName, Priority, ‘NEWLINE’, ‘’, ‘Requestors’, ‘CreatedRelative’, ‘ToldRelative’, ‘LastUpdatedRelative’, ‘TimeLeft
RT::DropLongAttachments 1
RT::EmailOutputEncoding iso-8859-1
RT::EtcPath /etc/request-tracker3.4
RT::FriendlyFromLineFormat “%s (SSC)” <%s>
RT::FriendlyToLineFormat “%s (SSC) Ticket #%s”:;
RT::LocalEtcPath /usr/local/share/request-tracker3.4/etc
RT::LocalLexiconPath /usr/local/share/request-tracker3.4/po
RT::LocalPath /usr/local/share/request-tracker3.4
RT::LogDir /var/log/request-tracker3.4
RT::LogToFile info
RT::LogToFileNamed rt.log
RT::LogToScreen error
RT::LogToSyslog error
RT::LogoURL https://xxx.de/NoAuth/images/ssc_logo.gif
RT::LoopsToRTOwner 1
RT::MailCommand sendmailpipe
RT::MasonComponentRoot /usr/share/request-tracker3.4/html
RT::MasonDataDir /var/cache/request-tracker3.4/mason_data
RT::MasonLocalComponentRoot /usr/local/share/request-tracker3.4/html
RT::MasonSessionDir /var/cache/request-tracker3.4/session_data
RT::MaxAttachmentSize 500000
RT::MaxInlineBody 13456
RT::MessageBoxWidth 72
RT::MessageBoxWrap HARD
RT::MinimumPasswordLength 5
RT::MyRequestsLength 10
RT::MyTicketsLength 10
RT::Organization xxx.de
RT::OwnerEmail mm@xxx.de
RT::ParseNewMessageForTicketCcs 1
RT::RTAddressRegexp ^ssc@xxx.de$
RT::RecordOutgoingEmail 1
RT::RedistributeAutoGeneratedMessages 1
RT::SITE_CONFIG_FILE /etc/request-tracker3.4/RT_SiteConfig.pm
RT::SendmailArguments -oi -t -f postmaster@elabnet.com
RT::SendmailPath /usr/sbin/sendmail
RT::Timezone Europe/Berlin
RT::UseFriendlyFromLine 1
RT::VERSION 3.4.1
RT::VarPath /var/cache/request-tracker3.4
RT::WebBaseURL https://xxx.de
RT::WebExternalAuth true
RT::WebFallbackToInternalAuth true
RT::WebFlushDbCacheEveryRequest 1
RT::WebImagesURL https://xxx.de/NoAuth/images/
RT::WebURL https://xxx.de/
RT::rtname SSC
Perl configuration

Summary of my perl5 (revision 5 version 8 subversion 4) configuration:
Platform:
osname=linux, osvers=2.6.15, archname=i386-linux-thread-multi
uname=‘linux ninsei 2.6.15 #1 smp preempt sat jan 7 12:47:52 pst 2006 i686 gnulinux ’
config_args=’-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN -Dcccdlflags=-fPIC -Darchname=i386-linux -Dprefix=/usr -Dprivlib=/usr/share/perl/5.8 -Darchlib=/usr/lib/perl/5.8 -Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5 -Dvendorarch=/usr/lib/perl5 -Dsiteprefix=/usr/local -Dsitelib=/usr/local/share/perl/5.8.4 -Dsitearch=/usr/local/lib/perl/5.8.4 -Dman1dir=/usr/share/man/man1 -Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1 -Dsiteman3dir=/usr/local/man/man3 -Dman1ext=1 -Dman3ext=3perl -Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Uusesfio -Uusenm -Duseshrplib -Dlibperl=libperl.so.5.8.4 -Dd_dosuid -des’
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define usemultiplicity=define
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc=‘cc’, ccflags =‘-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64’,
optimize=‘-O2’,
cppflags=‘-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -I/usr/local/include’
ccversion=‘’, gccversion=‘3.3.5 (Debian 1:3.3.5-13)’, gccosandvers=‘’
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype=‘long’, ivsize=4, nvtype=‘double’, nvsize=8, Off_t=‘off_t’, lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld=‘cc’, ldflags =’ -L/usr/local/lib’
libpth=/usr/local/lib /lib /usr/lib
libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
perllibs=-ldl -lm -lpthread -lc -lcrypt
libc=/lib/libc-2.3.2.so, so=so, useshrplib=true, libperl=libperl.so.5.8.4
gnulibc_version=‘2.3.2’
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=‘-Wl,-E’
cccdlflags=‘-fPIC’, lddlflags=‘-shared -L/usr/local/lib’

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 Joerg.Ungermann@web.de 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.