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
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