Very slow create ticket using postgres?

RT Users
1

Heya.

I’m just playing with trying to get rt2 running under postgres rather than
mysql.

things seem to be ok, however when I click on new ticket (in whatever queue)
it takes about a minute and a half to display the
next page!, it looks to be running some select on postgres that is running
the cpu upto like 80%-90%…

Any other postgres users experienced this??

Regards
Matthew Watson
Development, Netspace Online Systems
mwatson@netspace.net.au

2

possible reason…

Ok, I turned on logging in postres to level 2, so it logs transaction
starts and stops, and the sql statements in the transactions.