Tune PostgreSQL performance on Arm-based platforms

Who is this for?

This Learning Path is for database administrators (DBAs) and software developers who want to optimize PostgreSQL performance on Arm-based platforms.

What will you learn?

Upon completion of this Learning Path, you will be able to:

• Configure PostgreSQL settings that affect connection handling, memory use, write-ahead logging, query planning, and concurrency.
• Enable huge pages for PostgreSQL and size them for the shared memory area.
• Evaluate storage, kernel, compiler, and library choices that can affect PostgreSQL performance.

Prerequisites

Before starting, you will need the following:

• On-prem or cloud installation of PostgreSQL
• A repeatable PostgreSQL workload or benchmark that you can run before and after tuning