Feature Overview

When customers have database performance issues, we have a very limited amount of tests related to database performance checking.

PostgreSQL has a tool called pgbench that can perform standard tests + customized scripts for further testing providing information related to tps and average latency which could be essential for reporting issues in a customer's environment.

Background, and strategic fit

• pgbench is an official tool from Postgres
• this tool must be installed with the package postgresql-contrib

(Optional) Use Cases

• We should provide a PostgreSQL latency benchmark documentation with the required steps

Assumptions

• postgresql-contrib must be available on the repos
• the tests are generic in 4 tables created specifically for this benchmark, for a real-world scenario we might want to create a custom script and use the option -b scriptname[@weight] for a more realistic test

Currently tested options:
DB node:

dnf install postgresql-contrib -y
pgbench -i -h localhost awx -U awx
pgbench -S -c 10 -h localhost -T 20 awx -U awx

In controller node:

dnf install postgresql-contrib -y
pgbench -S -c 10 -h database_fqdn -T 20 awx -U awx

After the tests are done we can cleanup with:
DB node:

pgbench -i -I d -h localhost awx -U awx

Note: the option -I d is only available from pg 11 ahead. Pg 10 requires manual removal from the tables created by the -i option.