PostgreSQL on AmpereOne

PostgreSQL is a powerful, open-source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. PostgreSQL has a reputation of proven architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of the open-source community behind the software to consistently deliver performant and innovative solutions.

Figure 1 shows the energy efficiency of the three processors running PostgreSQL. The AmpereOne® A192-32X had a 39% better performance/watt compared to the AMD EPYC 9654, and 7% better than the AMD EPYC 9754.

PostgreSQL 13.1 was used for the tests with HammerDB 4.3 as the load generator. The test used is HammerDB’s TPCC-like OLTP test. The TPCC like workload causes each user to execute a combination of 5 different procedures on the DB: New Order, Payment, Delivery, Order-status, Stock-level. We scale the number of users such that the system is fully utilized to achieve maximum new orders per minute (NOPM). NOPM is the measured metric on the system under test.

AmpereOne® processors provide high performance for database solutions like Postgres. The performance AmpereOne processors combined with the 39% perf/watt advantage makes PostgreSQL deployments on the AmpereOne processors compelling.

All data and information contained herein is for informational purposes only and Ampere reserves the right to change it without notice. This document may contain technical inaccuracies, omissions and typographical errors, and Ampere is under no obligation to update or correct this information. Ampere makes no representations or warranties of any kind, including but not limited to express or implied guarantees of noninfringement, merchantability, or fitness for a particular purpose, and assumes no liability of any kind. All information is provided “AS IS.” This document is not an offer or a binding commitment by Ampere. Use of the products contemplated herein requires the subsequent negotiation and execution of a definitive agreement or is subject to Ampere’s Terms and Conditions for the Sale of Goods.

System configurations, components, software versions, and testing environments that differ from those used in Ampere’s tests may result in different measurements than those obtained by Ampere.

©2024 Ampere Computing. All Rights Reserved. Ampere, Ampere Computing, Altra and the ‘A’ logo are all registered trademarks or trademarks of Ampere Computing. Arm is a registered trademark of Arm Limited (or its subsidiaries). All other product names used in this publication are for identification purposes only and may be trademarks of their respective companies.

Ampere Computing^® / 4655 Great America Parkway, Suite 601 / Santa Clara, CA 95054 / amperecomputing.com