Re: Beginning tuning

On Tue, 6 Nov 2007, Phillip Mills wrote:

> One of the first things I've noticed out of a number of thread dumps is that
> there's about an 80% chance that the stack points to I/O requests from
> PGStream.ReceiveChar().  I'm wondering about any hints or pointers that
> would help me understand whether that's expected behavior, or something that
> needs fixing, or just generally how to evaluate/improve JDBC performance.
>

The ReceiveChar call is waiting for data from the backend.  I'm not sure
how you're identifying blocked threads, but ReceiveChar is a blocking call
underneath the hood.  So this just shows that the driver is waiting while
queries are executing which is perfectly expected.

Kris Jurka