Tutorial: Install and compile PostgreSQL on IBM Power Systems servers

Compilation of PostgreSQL for optimized performance

By Arihant Soundara Raghavan, Calvin Sze, Krishna Harsha Voora, Lilian Romero, Mithun H R
Published December 11, 2020

Introduction

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.