Very slow create ticket using postgres?


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

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??

Matthew Watson
Development, Netspace Online Systems

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.