public inbox for [email protected]
help / color / mirror / Atom feedFrom: zaidagilist <[email protected]>
To: Edwin UY <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: PostgreSQL Load Testing
Date: Tue, 20 May 2025 17:15:56 +0500
Message-ID: <CAFS1Kf7P-eB8a0zZFmp-wjhfSpoqr1o-L6JaToV0UbFDd1diWA@mail.gmail.com> (raw)
In-Reply-To: <CA+wokJ8Cckx+xH3jKy8kirRmqUBcSxtAJVd35Kn1LKunoOxaMQ@mail.gmail.com>
References: <CA+wokJ8Cckx+xH3jKy8kirRmqUBcSxtAJVd35Kn1LKunoOxaMQ@mail.gmail.com>
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%20perfo...
<https://www.hammerdb.com/#:~:text=HammerDB%20is%20built%20and%20tested,time%20and%20collated%20perfo...;
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 <[email protected]> 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?
>
>
>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: PostgreSQL Load Testing
In-Reply-To: <CAFS1Kf7P-eB8a0zZFmp-wjhfSpoqr1o-L6JaToV0UbFDd1diWA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox