[rt-devel] 3.0.4 Perfomance

mixo mixo at coza.net.za
Mon Aug 18 06:25:22 EDT 2003


I have just finished importing data from rt2(2.0.9) into two instances 
of RT3 (3.0.4) on
separate machines. The one instance has mysql, and the other pgsql. The 
time it take
to display a ticket on each instances does vary much, but loggin in to 
the pgsql
take a very long time. Which leads me to ask: are there any known issues 
with rt 3.0.4
and pg?

Here is a sample of the times:
+++++++++++++++++++++++++++++++++++++++++++++++
RT login using "curl": ('time curl http://localurl/ -d user=me -d 
pass=mypass')
Mysql
----
real    0m3.491s
user    0m0.020s
sys     0m0.020s

Pgsql
-----
real    18m36.627s (way too long)
user    0m0.020s
sys     0m0.000s
+++++++++++++++++++++++++++++++++++++++++++++++

Displaying ticket 8000 ('time  curl  
http://localurl/SelfService/Display.html -d user=me -d pass=mypass -d 
id=8000')
Mysql
-----
real    0m2.227s
user    0m0.020s
sys     0m0.020s

Pgsql
-----
real    0m9.997s
user    0m0.000s
sys     0m0.020s
+++++++++++++++++++++++++++++++++++++++++++++++

postgresql-7.3.2
mysql-3.23.56





More information about the Rt-devel mailing list