Power Developer eXchange A place for IBM Power open source developers to learn, collaborate, contribute, and create Join / Log in
Compilation of PostgreSQL for optimized performance
By Arihant Soundara Raghavan, Calvin Sze, Krishna Harsha Voora, Lilian Romero, Mithun H RPublished December 11, 2020
The primary focus of this tutorial is to study PostgreSQL database configuration with supported compilers such as GCC, LLVM, and IBM® Advance Toolchain on IBM Power Systems™ servers. Red Hat® Enterprise Linux (RHEL) 8.1 was used as the operating system with PostgreSQL installed on IBM Power Systems featuring the new IBM POWER9™ processor technology. PostgreSQL is an open source database that can handle a wide variety of high-volume transactions and heavy-reporting workloads. At the end of the study, users can understand the different compilers that can be used on IBM Power Systems servers with PostgreSQL. The tutorial briefly describes the testbed topology and shows how the configuration, tuning, and test runs were performed.