EDB Postgres AI Outperforms Oracle, SQL Server, MongoDB, and MySQL in Benchmark Tests
EDB Postgres AI, the latest PostgreSQL-based database from EnterpriseDB (EDB), has outperformed four other databases, including Oracle, SQL Server, MongoDB, and MySQL, on a pair of benchmark tests that span SQL and NoSQL workloads.
TPC-C-like Test
The vendor commissioned McKnight Consulting Group to run a pair of benchmark tests to measure the relative performance of EDB Postgres AI against relational and non-relational databases. McKnight set up a TPC-C-like test to compare the transaction processing prowess of EDB Postgres AI against Oracle and Microsoft SQL Server, while it set up a JSON processing test to compare the multi-modal database against MongoDB and MySQL, which is controlled by Oracle and can also process JSON documents.
Results
On the new orders per minute (NOPM) transactional test, McKnight measured EDB Postgres AI hitting a peak throughput of about 987,000 NOPM compared to about 844,000 for Oracle and about 759,000 for SQL Server. The tests were performed on identical AWS environments: ixi8xlarge instances running in US East 1, which cost $24,055 per year to run.
Price-Per-Performance Comparisons
The price-per-performance comparisons were starker. According to McKnight, EDB Postgres AI was able to achieve an NOPM cost of $0.21 per unit compared to Oracle’s $1.58 and SQL Server’s $1.26. The differences are due to the higher cost of the Oracle ($47,500 per unit) and Microsoft ($15,123 per unit) software environments compared to EDB ($2,780 per unit), as well as higher support costs ($10,450 per unit for Oracle and $3,327 per unit for Microsoft versus zero for EDB).
JSON Processing Test
An entirely different test was used for the JSON workload, but the same AWS instances were used. For the JSON test, McKnight used PG NoSQL Benchmark, which is a benchmark tool created by EDB to test PostgreSQL and MongoDB databases. McKnight modified the syntax of the benchmark to include MySQL, which also is capable of processing JSON data.
Results
EDB Postgres AI beat the other two databases across all three JSON tests. For bulk loads, EDB was 34% faster than MongoDB and 63% faster than MySQL. For database INSERTS, EDB was 4 times faster than MySQL and 150 times faster than MongoDB. For the SELECT query, EDB was on average almost 3 times faster than MySQL and more than 5 times faster than MongoDB. More details of the test setup and results can be found in McKnight’s report here.
Conclusion
EDB Postgres AI’s performance in these benchmark tests demonstrates its ability to handle both relational and non-relational workloads, making it a strong contender in the database market. With its open-source heritage and strong community support, EDB Postgres AI is an attractive option for organizations looking for a database that can handle a wide range of workloads and provide high performance at a lower cost.
Frequently Asked Questions
Q: What were the results of the TPC-C-like test?
A: EDB Postgres AI achieved a peak throughput of about 987,000 NOPM, outperforming Oracle’s 844,000 and SQL Server’s 759,000.
Q: What were the price-per-performance comparisons for the TPC-C-like test?
A: EDB Postgres AI achieved an NOPM cost of $0.21 per unit, compared to Oracle’s $1.58 and SQL Server’s $1.26.
Q: What were the results of the JSON processing test?
A: EDB Postgres AI beat the other two databases across all three JSON tests, with performance gains ranging from 34% to 150% compared to MongoDB and MySQL.
