Beginning tuning

Поиск
Список
Период
Сортировка
От Phillip Mills
Тема Beginning tuning
Дата
Msg-id dd0408e50711060609n4ca6d049kac9f1bf356d1da4d@mail.gmail.com
обсуждение исходный текст
Ответы Re: Beginning tuning  (Dave Cramer <pg@fastcrypt.com>)
Re: Beginning tuning  (Kris Jurka <books@ejurka.com>)
Re: Beginning tuning  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-jdbc
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.)

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: How to get the SQL query from a PreparedStatement?
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Beginning tuning