Re: time to stop tuning?

> 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(at)sitesell(dot)com>