review: pgbench progress report improvements

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: coelho(at)cri(dot)ensmp(dot)fr
Subject: review: pgbench progress report improvements
Date: 2013-09-11 13:39:03
Message-ID: CAFj8pRAVYUhv8x3fEEwaSGGvDcijOgVLZSAVd7rmWn9Mw8RANA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

* patched with minor warning
* compilable cleanly
* zero impact on PostgreSQL server functionality
* it does what was in proposal
** change 5sec progress as default (instead no progress)
** finalise a rate limit support - fixes a latency calculation
* code is clean
* documentation is included
* there is no voices against this patch and this patch increases a pgbench
usability/

I have only one question. When I tested this patch with throttling I got a
very similar values of lag.

[pavel(at)localhost ~]$ /usr/local/pgsql/bin/pgbench -T100 -j4 -c32 postgres
-R 60
starting vacuum...end.
progress: 5.0 s, 61.3 tps, 15.796 +- 11.287 ms lat, 0.118 ms lag
progress: 10.0 s, 60.8 tps, 16.527 +- 12.965 ms lat, 0.120 ms lag

[pavel(at)localhost ~]$ /usr/local/pgsql/bin/pgbench -T100 -j4 -c32 postgres
-R 80
starting vacuum...end.
progress: 5.0 s, 78.8 tps, 17.009 +- 11.666 ms lat, 0.163 ms lag
progress: 10.1 s, 74.3 tps, 33.510 +- 55.456 ms lat, 0.092 ms lag

[pavel(at)localhost ~]$ /usr/local/pgsql/bin/pgbench -T100 -j4 -c32 postgres
-R 40
starting vacuum...end.
progress: 5.2 s, 39.4 tps, 13.580 +- 10.283 ms lat, 0.182 ms lag
progress: 10.1 s, 49.3 tps, 13.192 +- 6.772 ms lat, 0.135 ms lag

What is sense, or what is semantic of this value? It is not detailed
documented. Should be printed this value in this form on every row? We can
print some warning when lag is higher than latency instead? Or we can use
this value, but it should be better documented, please.

Regards

Pavel Stehule

some minor issue:

patch warning

make[1]: Leaving directory `/home/pavel/src/postgresql/config'
[pavel(at)localhost postgresql]$ patch -p1 < pgbench-measurements-v2.patch
(Stripping trailing CRs from patch; use --binary to disable.)
patching file contrib/pgbench/pgbench.c
(Stripping trailing CRs from patch; use --binary to disable.)
patching file doc/src/sgml/pgbench.sgml

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ronan Dunklau 2013-09-11 14:14:22 Re: Triggers on foreign tables
Previous Message Michael Paquier 2013-09-11 13:27:24 Re: Triggers on foreign tables