Driver performance improvements - kudos to the maintainers and the contributors

From: zloster <more(at)edno(dot)moe>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Driver performance improvements - kudos to the maintainers and the contributors
Date: 2017-04-13 19:54:54
Message-ID: b932aed17f22b21ea1ab51cfd70d569f@edno.moe
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi all,

I don't know if you are familiar with the TechEmpower Framework
Benchmarks project. I'm keeping an eye on it. If you dig into the
numbers and understand the test intentions and limitations it gets quite
interesting.
The occasion to write this is very recent comment from a TechEmpower
team guy:

> bhauer commented:
> Yes! The database tests are intended to be a brutal exercise of the
> database drivers and ORM (where applicable). You're
> right that it stands to reason that tuning in the driver will show up
> as a significant gain in these tests, assuming
> that in so doing you don't reach a different bottleneck in the
> framework itself. Nevertheless, the delta in this
> particular test was a big surprise. The Postgres JDBC driver folks
> deserve a lot of credit for tuning the drivers up so well!

Source:
https://github.com/TechEmpower/FrameworkBenchmarks/pull/2626#issuecomment-293968949

Disclaimer: the results are preliminary, but seems inline with several
other frameworks that are using Java/PostgreSQL/PgJDBC.

The reason is simple update of the JDBC driver from 9.4.1200 to
9.4.1208. "Gemini" is their own web framework implementation based on
Java.
The environment hardware is: Dell R910 (4x 10-Core E7-4850 CPUs)
application server; Dell R710 (2x 4-Core E5520 CPUs) for the database
server and the load-generator; switched 10-gigabit Ethernet.

The delta that he mentions is:

gemini-postgres db 65,971 173,689 +163.3%
gemini-postgres query 2,762 7,799 +182.3%
gemini-postgres update 993 1,932 +94.5%
gemini-postgres fortune 76,826 179,447 +133.6%

All numbers are HTTP requests per second.
The "db test" is using simple "SELECT id, value FROM world WHERE id = ?"
and "id" is randomly chosen. The table is 10000 rows.
The "query test" is using the same setup but each HTTP request will
issue 20 SQL queries as above.
The "update test" is using the same setup but each HTTP request will
issue 20 read SQL queries and 20 update queries.
The "fortune test" is different. It reads all rows from a table with 12
rows. The columns are two: numerical id and string.

The current preview data is here:
https://www.techempower.com/benchmarks/previews/round14/r14p2-vs-r14p3.html#gemini-postgres.db

Maybe [pgsql-advocacy] mailing list will be also interested?

Once again congratulations for your great work.

--
Best regards,
zloster

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message akshunj 2017-04-14 20:20:08 Re: how to get JDBC driver version from command line
Previous Message Stefan Smith 2017-04-12 18:53:19 Re: Logical Replication: adjacent COMMIT messages with the wrong StartLSN