pgsql: Change the way latency is calculated with pgbench --rate option.

From: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Change the way latency is calculated with pgbench --rate option.
Date: 2014-09-11 09:57:58
Message-ID: E1XS18Y-00083X-Q9@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Change the way latency is calculated with pgbench --rate option.

The reported latency values now include the "schedule lag" time, that is,
the time between the transaction's scheduled start time and the time it
actually started. This relates better to a model where requests arrive at a
certain rate, and we are interested in the response time to the end user or
application, rather than the response time of the database itself.

Also, when --rate is used, include the schedule lag time in the log output.

The --rate option is new in 9.4, so backpatch to 9.4. It seems better to
make this change in 9.4, while we're still in the beta period, than ship a
9.4 version that calculates the values differently than 9.5.

Branch
------
REL9_4_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/8c9dd69fc2638701653c90bbf291884f8ca23d56

Modified Files
--------------
contrib/pgbench/pgbench.c | 164 +++++++++++++++++++++++++++++++--------------
doc/src/sgml/pgbench.sgml | 59 ++++++++--------
2 files changed, 146 insertions(+), 77 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2014-09-11 10:14:09 pgsql: Simplify calculation of Poisson distributed delays in pgbench --
Previous Message Andres Freund 2014-09-11 07:27:00 Re: pgsql: Add new psql help topics, accessible to both --help and \?.