Re: pgbench --latency-limit option - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: pgbench --latency-limit option
Date
Msg-id alpine.DEB.2.10.1512231903580.22350@sto
Whole thread Raw
In response to Re: pgbench --latency-limit option  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
>> [...]
>> Because the schedule is based on a stochastic process, transactions are not
>> set regularly (that would induce patterns and is not representative of
>> real-life load) but randomly.
>>
>> The long term average is expected to converge to 2 tps, but on a short run
>> it may differ significantly.
>
> Hmm.  Is that documented somewhere?

Sure, see --rate option in pgbench doc, which states:

"The rate is targeted by starting transactions along a Poisson-distributed 
schedule time line."

The impact on the tps is implied, though.

-- 
Fabien.



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Using quicksort for every external sort run
Next
From: Robert Haas
Date:
Subject: Re: Parallel Aggregate