> On limiting the client side connections: we've been gradually pushing up > the client-side connection pool and threads, and have seen steady > improvement in our throughput up to the current barrier we have reached. Very well.. Sometimes more simultaneous workers helps, other times it hinders. > I've attached the plans for the 4 queries that represent ~35% of our > load. These are run against the same dataset, but without any other > load. Another big query basically requires a test to be runnning because Those aren't likely from your production system as there isn't any data in those tables and the queries took less than 1ms. -- Rod Taylor <rbt@xxxxxxxxxxxx>
