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

From Heikki Linnakangas
Subject pgsql: Change the way latency is calculated with pgbench --rate option.
Date
Msg-id E1XS18Y-00083X-Q9@gemulon.postgresql.org
Whole thread Raw
List 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(-)


pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: Re: pgsql: Add new psql help topics, accessible to both --help and \?.
Next
From: Heikki Linnakangas
Date:
Subject: pgsql: Change the way latency is calculated with pgbench --rate option.