From: Lazaro Garcia <lazaro3487@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Help bad results with pgbench
Date: Mon, 10 Apr 2017 11:09:42 -0400
Message-ID: <003101d2b20c$7d2f4fd0$778def70$@gmail.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Good morning everyone.
I'm having the following problem with pgbench and test again:
I create a database with a scale of 200 and execute a test (read only) with
40 users and this is the result:
pgbench -U postgres -p 5433 -j 10 -c 40 -T 30 -h 127.0.0.1 -S pgbench
scaling factor: 200
query mode: simple
number of clients: 40
number of threads: 10
duration: 30 s
number of transactions actually processed: 2682306
latency average = 0.446 ms
latency stddev = 0.303 ms
tps = 89329.960851 (including connections establishing)
tps = 89348.642359 (excluding connections establishing)
Then restart the server and when I run the test again the result is really
very bad and the IO starts to climb (here the weird thing is that I'm not
writing just reading)
scaling factor: 200
query mode: simple
number of clients: 40
number of threads: 10
duration: 30 s
number of transactions actually processed: 6933
latency average = 174.032 ms
tps = 229.842173 (including connections establishing)
tps = 229.870409 (excluding connections establishing)
Can someone give me some suggestions so I can determine what's going on?
PostgreSQL 9.6.2.
Thank you very much for your time.
Regards.
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-admin@postgresql.org
Cc: lazaro3487@gmail.com
Subject: Re: Help bad results with pgbench
In-Reply-To: <003101d2b20c$7d2f4fd0$778def70$@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 DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox