Have you tried running the queries from different processes? In my testing these did scale pretty well. I was using mmap and was seeing good scaling up to 16 single threaded processes that were all querying the database none stop. That was done on an anemic VM and my test db was quite larger than RAM so probably could scale further if I had access to more cpu power.