From: Tatsuo Ishii <t-ishii@sra.co.jp>
To: hackers@postgreSQL.org
Subject: Announcement: pgbench-1.1 released
Date: Thu, 30 Sep 1999 10:15:59 +0900
Message-ID: <199909300115.KAA01268@ext16.sra.co.jp> (raw)
Hi,
I have made a small tool called "pgbench," that may be useful for
some stress testings and performance measurements for PostgreSQL.
pgbench can be obtained from:
ftp://ftp.sra.co.jp/pub/cmd/postgres/pgbench/
Pgbench runs small transactions similar to TPC-B concurrently and
reports the number of transactions actually done per second (tps).
Pgbench uses the asynchronous functions of libpq to simulate
concurrent clients. Example outputs from pgbench are shown below:
number of clients: 4
number of transactions per client: 100
number of processed transactions: 400/400
tps = 19.875015(including connections establishing)
tps = 20.098827(excluding connections establishing)
(above result was reported on my PowerBook with 603e CPU(180MHz), 80MB
mem running PostgreSQL 6.5.2 with -F option, and Linux 2.2.1 kernel)
Pgbench does not require any special libraries other than libpq. It
comes with a configure script and should be very easy to build.
*CAUTION*
pgbench will blow away tables named accounts, branches, history and
tellers. It is best to create a new database for pgbench before
running it.
BTW, the greatest tps I have ever seen was around 260 on a Linux box
running RedHat 6.0, having 2 Pentiumn III 600MHz CPUs and 512MB mem.
Enjoy,
---
Tatsuo Ishii
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: pgsql-interfaces@postgresql.org
Cc: t-ishii@sra.co.jp, hackers@postgreSQL.org
Subject: Re: Announcement: pgbench-1.1 released
In-Reply-To: <199909300115.KAA01268@ext16.sra.co.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox