EnterpriseDB has begun running comparison tests to help Postgres users better assess the NoSQL capabilities of Postgres. The tests compare PostgreSQL (often called Postgres) with MongoDB as recent advances have significantly enhanced Postgres’ capacity to support document databases.
We are inviting an open review of our test results and our framework. We’ve made the materials available (see below for information) for the Postgres and MongoDB communities to examine the results and even duplicate our test or develop new ones. Our goal is to encourage greater participation in exploring Postgres as its NoSQL technology continues to expand to meet evolving enterprise workloads.
In testing, EDB has found that Postgres outperforms MongoDB in selecting, loading and inserting complex document data in key workloads:
- Ingestion of high volumes of data was 2.2 times faster with Postgres
- MongoDB consumed 35% more disk space
- Data inserts took three times longer with MongoDB than Postgres
- Data selection took almost three times as long with MongoDB than Postgres
The results demonstrate that the recent JSON enhancement to Postgres for unstructured data perform very well, and in our initial testing shows performance at levels better than, or on par with, the more specialized MongoDB solution. What is compelling is that these document database capabilities in Postgres simultaneously enable developers to take advantage of Postgres’ stability and ACID compliance. Our customers report that this advantage eliminates data silos and promotes easier data governance when compared to the specialized solution. Postgres provides users the technology they need to address some critical new data challenges without taking on the risks and incremental cost of a NoSQL-only solution, which can introduce a host of management and data integrity challenges.Tweet