Extremely slow SQL queries after RT3 to RT4 upgrade

[Ian_Miller]

My experience was similar, but with postgresql. The thing that finally cracked it was shrinking the cached group members table.

See this thread:

Performance problems with postgres and rt4.2

Hi, We’re long time users of RT and we love it. However, our existing installation (RT3.6.6 on FreeBSD) is getting rather old so we’re attempting an upgrade. We have around 300,000 tickets, 200 intermittent privileged users The plan is to move to RT4.2.15 on a newUbuntu VM, by using the deb packages. We’ve got it installed and working OK and like the improvements from our older version. We’ve also imported and updated the old database successfully onto a dedicated postresql 9.5 host (lots of f…