From: | Ken Geis <kgeis(at)speakeasy(dot)net> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | tuning/profiling |
Date: | 2005-10-19 15:57:41 |
Message-ID: | 4cc26110e08d1241396f0e019466e2f1@speakeasy.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi. I just did some investigation into improving the performance of
the JDBC driver. I want the best performance for my application, and I
would love to be able to make PostgreSQL more competitive.
I wrote a simple benchmark that would be doing an action common in my
application (fetch ~11000 rows from a table with a date, four
numeric(9,4) columns, and an integer.) I ran this through a profiler
and found some hot spots. In the end, I was able to squeeze out at
least 50% improvement with a small amount of changes to driver code.
Before I submit patches, I must run my changes against the test suite
and other benchmarks. Then I will break my patches into independent
pieces. Some of my changes may be controversial because they may be
less robust than current, but I am making some assumptions about the
server protocol (like that date strings will never contain Unicode
digits.)
Does anyone have a benchmark they'd like me to run? I could run
ECPerf, PolePosition, TPC-W, or Jdbcbench.
Ken
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Geis | 2005-10-19 15:59:43 | binary data transfers |
Previous Message | Kevin Grittner | 2005-10-19 15:42:59 | Re: How to bulk load a schema using JDBC multiple |