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

From Robert Haas
Subject Re: pgbench --latency-limit option
Date
Msg-id CA+TgmoaOTopo74O7UkvJE6uyJknj3jApZ27cj+6r9g09N-LDDQ@mail.gmail.com
Whole thread Raw
In response to Re: pgbench --latency-limit option  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: pgbench --latency-limit option
List pgsql-hackers
On Wed, Dec 23, 2015 at 9:52 AM, Fabien COELHO <coelho@cri.ensmp.fr> wrote:
>> In your example, you've got 10 connections and are trying to run at 2
>> tps, so to avoid having to start skipping things you need transaction
>> response times to be <~ 5 ms.  The actual response time is ~5.5ms, so
>> if you ran the test for longer I think you would see some skips.
>
> 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?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: Let PostgreSQL's On Schedule checkpoint write buffer smooth spread cycle by tuning IsCheckpointOnSchedule?
Next
From: Tom Lane
Date:
Subject: Re: [PROPOSAL] Backup and recovery of pg_statistic