JDBC performance
| От | Keith L. Musser |
|---|---|
| Тема | JDBC performance |
| Дата | |
| Msg-id | 004301c028a1$0cddebd0$0201a8c0@quantum.idisys.com обсуждение исходный текст |
| Список | pgsql-general |
Hi, I'm new to PostgreSQL. I'm using JDBC7.0-1.2.jar and PostgreSQL 6.5.2. Just to understand performance, I'm running a set of repeated queries on the same data, selecting one row by primary key. I'm running them as fast as the CPU can go. I'm finding that for these simple queries on an indexed table, my CPU spends about 60% of the time in JDBC, and about 40% of the time in the postmaster backend. (Each query takes 2 msec on my machine, RH Linux 6.2, 733 MHz Intel, w/ lots of memory.) I was hoping the client-side overhead would be less. (a) Any hints on getting good performance when using JDBC? (b) How much better is the client-side overhead if I were using C instead of Java? (c) Do many of you use Java to access PGSQL? Keith L. Musser Integrated Dynamics, Inc. 812-371-7777 email: kmusser@idisys.com
В списке pgsql-general по дате отправления: