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