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