tuning/profiling - Mailing list pgsql-jdbc

From Ken Geis
Subject tuning/profiling
Date
Msg-id 4cc26110e08d1241396f0e019466e2f1@speakeasy.net
Whole thread Raw
List 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


pgsql-jdbc by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: How to bulk load a schema using JDBC multiple
Next
From: Ken Geis
Date:
Subject: binary data transfers