Re: pgbench --latency-limit option

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: pgbench --latency-limit option
Дата
Msg-id CA+TgmoaOTopo74O7UkvJE6uyJknj3jApZ27cj+6r9g09N-LDDQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgbench --latency-limit option  (Fabien COELHO <coelho@cri.ensmp.fr>)
Ответы Re: pgbench --latency-limit option  (Fabien COELHO <coelho@cri.ensmp.fr>)
Список 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 по дате отправления:

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: Let PostgreSQL's On Schedule checkpoint write buffer smooth spread cycle by tuning IsCheckpointOnSchedule?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PROPOSAL] Backup and recovery of pg_statistic