Mike, I use mysql, but I'm curious if you found resolution to this topic? I'm interested in fixing quiz performance problems for our 2.3 instance.
I got down a path where I was looking at cron jobs and potential inefficiency related to row-locks, wondering if there's any correlation with your cron period and stale transactions. (probably a red herring, but thought it may be worth a look)