Its been a busy week for me. Looking at postgresql, there seems to be a bottle neck. For some reason when you keep on hammering it on a multi cpu server. The cpu utilization lowers from 100% to 40%.
Hopefully I get to the bottom of it, its an interesting problem.