From: | Dave Cramer <pg(at)fastcrypt(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 14:32:13 |
Message-ID: | EB989312-B4F6-455A-9D15-9081AAB080FC@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Phillip,
You'd have to give us a lot more information than this to help you.
machine specs ?
Postgresql version and jdbc version
postgresql configuration
are you using a db pool ?
Dave
On 6-Nov-07, at 9:09 AM, Phillip Mills wrote:
> I'm just getting started on the process of analyzing performance for
> a Java Enterprise application. (The main negative symptom at the
> moment is that it doesn't use more than three processors on an eight-
> processor system, regardless of load.)
>
> 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.
>
> (Regarding the main problem, none of my threads are reported in a
> blocked state, leading to my focus on I/O.)
From | Date | Subject | |
---|---|---|---|
Next Message | Phillip Mills | 2007-11-06 14:51:54 | Re: Beginning tuning |
Previous Message | Phillip Mills | 2007-11-06 14:09:35 | Beginning tuning |