PostgreSQL Database Server

PostgreSQL Performance Summary

The following charts show the performance of PostgreSQL (in green) relatively to other JPA/DBMS combinations (in gray).

Position #1 on the X-Axis (the fastest) is about 100 times faster than position #32 (the slowest).
In the chart below the Y-Axis represents result score (maximum 100) in logarithmic scale - higher is better:
JPA performance benchmark comparision Hibernate, EclipseLink, OpenJPA, DataNucleus, ObjectDB
In the chart below the Y-Axis represents result score (maximum 100) in linear scale - higher is better:
JPA performance benchmark comparision Hibernate, EclipseLink, OpenJPA, DataNucleus, ObjectDB


The configurations in which PostgreSQL has been tested are listed in the following table:

 Database + JPA ProviderNormalized Score
100 - Best,  0 - Worst
Final Position
1 - Best,  32 - Worst
Failed Tests
1Hibernate with PostgreSQL server10.78  (out of 32)1
2EclipseLink with PostgreSQL server10.49  (out of 32)2
3DataNucleus with PostgreSQL server5.715  (out of 32)6
4OpenJPA with PostgreSQL server4.121  (out of 32)5

As shown above, PostreSQL was faster when used with Hibernate or EclipseLink as a JPA provider.

Comparing the results of PostreSQL in this benchmark to the results of other RDBMS servers (excluding ObjectDB and embedded database results) reveals that PostreSQL was the fastest RDBMS database server.

About PostgreSQL

PostreSQL is an object-relational database management system (ORDBMS). It evolved from the Ingres database. Its first version was released in 1989.

PostreSQL is available under the open source PostgreSQL license.

In this benchmark PostreSQL version 8.4.4 (which was released in 2010) has been tested.

To avoid flush to the disk on every transaction by PostgreSQL (which affects the performance of insert/update/delete mainly in small transactions) the fsync configuration option has been set to off.