> 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@sitesell.com>