Re: PostgreSQL Load Testing

Hello Edwin,

A couple of open-source PostgreSQL load testing tools are available. As
mentioned in the previous thread, pgbench is the native and reliable
option. However, there are a few other dependable tools as well. The
following table may help you choose the right tool based on your
requirements.

Tool CLI/GUI Primary Load Type DB Integration CPU/I/O/Memory Stress Output
Interface Reference Link
pgbench CLI only PostgreSQL transactions (OLTP) Uses libpq (built-in) SQL
transactions (stresses CPU + disk I/O) Plain-text
https://www.postgresql.org/docs/current/pgbench.html
HammerDB GUI + CLI TPC-C/TPC-H style OLTP/OLAP Pgtcl (PostgreSQL) Realistic
OLTP/OLAP workload (high CPU and I/O) GUI charts + CLI console, real-time
metrics
https://www.enterprisedb.com/blog/how-to-benchmark-postgresql-using-hammerdb-open-source-tool

https://www.hammerdb.com/#:~:text=HammerDB%20is%20built%20and%20tested,time%20and%20collated%20performance%20analysis
<https://www.hammerdb.com/#:~:text=HammerDB%20is%20built%20and%20tested,time%20and%20collated%20performance%20analysis>
JMeter GUI + CLI General load (incl. JDBC/SQL) JDBC driver for PG Throughput
of user-defined SQL queries (CPU/I/O via queries) GUI listeners, HTML
reports; console log
https://jmeter.apache.org

https://princepereira.medium.com/evaluating-postgresql-db-with-apache-jmeter-a8524d618371
Sysbench CLI only CPU, memory, file I/O Via libpq Dedicated CPU, RAM or
disk benchmarks; OLTP SQL Plain-text
https://github.com/akopytov/sysbench

Regards,
Zaid

On Mon, May 19, 2025 at 5:21 AM Edwin UY <edwin(dot)uy(at)gmail(dot)com> wrote:

> Hi,
>
> Anyone know any 'free' scripts to use for load testing, I/O, memory and
> CPU?
> For PostgreSQL on-prem and AWS RDS+Serverless maybe?
>
>
>