Skip site navigation (1) Skip section navigation (2)

Re: Beginning tuning

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 (view raw or flat)
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.)


In response to

Responses

pgsql-jdbc by date

Next:From: Phillip MillsDate: 2007-11-06 14:51:54
Subject: Re: Beginning tuning
Previous:From: Phillip MillsDate: 2007-11-06 14:09:35
Subject: Beginning tuning

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group