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).
The configurations in which PostgreSQL has been tested are listed in the following table:
|Database + JPA Provider||Normalized Score|
100 - Best, 0 - Worst
1 - Best, 32 - Worst
|1||Hibernate with PostgreSQL server||10.7||8 (out of 32)||1|
|2||EclipseLink with PostgreSQL server||10.4||9 (out of 32)||2|
|3||DataNucleus with PostgreSQL server||5.7||15 (out of 32)||6|
|4||OpenJPA with PostgreSQL server||4.1||21 (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.
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)
fsync configuration option has been set to