Re: Beginning tuning - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Beginning tuning
Date
Msg-id 47322D1C.4040405@opencloud.com
Whole thread Raw
In response to Beginning tuning  ("Phillip Mills" <pmills@systemcore.ca>)
List pgsql-jdbc
Phillip Mills wrote:

> (Regarding the main problem, none of my threads are reported in a
> blocked state, leading to my focus on I/O.)

BTW, this is because Sun JVM thread dumps and JVMPI/JVMTI generally
consider a thread currently in a native method to be "running"
regardless of what it's actually doing. In the case of a network read
(implemented as a native method), it's actually most likely to be
blocked in the kernel waiting on more data from the server. Makes for
fun when profiling, I've had to build tools to explicitly exclude "is
probably blocked" native methods from profile results to get anything
useful on systems that are mostly I/O bound :(

-O

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Beginning tuning
Next
From: Daniel Campelo
Date:
Subject: Re: Schema in URL