| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Phillip Mills <pmills(at)systemcore(dot)ca> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Beginning tuning |
| Date: | 2007-11-06 19:42:56 |
| Message-ID: | Pine.BSO.4.64.0711061437540.6917@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 田忠磊 | 2007-11-07 06:25:19 | can i get your help? |
| Previous Message | Phillip Mills | 2007-11-06 16:20:25 | Re: Beginning tuning |