Re: pgbench - compute & show latency consistently - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: pgbench - compute & show latency consistently
Date
Msg-id alpine.DEB.2.20.1607131015370.7486@sto
Whole thread Raw
In response to Re: pgbench - compute & show latency consistently  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: pgbench - compute & show latency consistently  (Heikki Linnakangas <hlinnaka@iki.fi>)
List pgsql-hackers
Hello Peter,

>>  number of transactions per client: 1000
>> -latency average = 15.844 ms
>> +latency average: 15.844 ms
>>  tps = 618.764555 (including connections establishing)
>
> I think what you have here is that colons separate input parameters and
> equal signs separate result output.  So I think it's OK the way it is.

Hmmm... Then other measures displayed are not all consistent with this
theory.

Also there is still the bug under -t which displays a 0 latency.

The attached patch still fixes that and make it consistent the other way
around, i.e. by using "=" for latency. I switched to use ":" for weight
which is an input parameter. I let ":" when there is a long sentence to
describe the figure displayed, more on aesthetical grounds.

> Maybe a better improvement would be introducing section headings like
> "test parameters" and "test results".

This would add more lines to the report, to sure how desirable it is.

--
Fabien.
Attachment

pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: pgbench - minor fix for meta command only scripts
Next
From: Ashutosh Bapat
Date:
Subject: Re: Oddity in handling of cached plans for FDW queries