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.1512231714520.22350@sto
Whole thread Raw
In response to Re: pgbench --latency-limit option  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: pgbench --latency-limit option  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
>> Probably no skips though, because the response time needed is below 5
>> *seconds*, not ms : 2 tps on 10 connections, 1 transaction every 5 seconds
>> for each connection.
>
> Oops.  Right.  But why did this test only run 16 transactions in total
> instead of 20?

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.

-- 
Fabien.



pgsql-hackers by date:

Previous
From: Ildus Kurbangaliev
Date:
Subject: Re: Review: GiST support for UUIDs
Next
From: Robert Haas
Date:
Subject: Re: pgbench --latency-limit option