On 09/05/2014 02:40 PM, Heikki Linnakangas wrote:
> Are you measuring wall-clock time or CPU time? If it's CPU time, I'm
> surprised that the I/O-related syscalls, poll(), send() and recv(), are
> so high on the profile. If not, there isn't much you can do in the
> client side to make them faster, as the time is simply spent waiting for
> the server.
There's still potentially one big thing that can be done: reduce
round-trips.
For example, the PgJDBC driver sends multi-statements to the server by
writing a bunch of bind/parse/execute messsages, *then* waiting for a
response and processing each response as it receives it.
It can be worth looking at what's happening on the wire.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services