Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement)

Поиск
Список
Период
Сортировка
Искать
От
Fabien COELHO
Тема
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement)
Дата
Msg-id
alpine.DEB.2.02.1306192034560.25404@localhost6.localdomain6
Ответ на
Список
Дерево обсуждения
[PATCH] pgbench --throttle (submission 4) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 5) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 6) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Robert Haas <robertmhaas@gmail.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Tatsuo Ishii <ishii@postgresql.org>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Tatsuo Ishii <ishii@postgresql.org>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Tatsuo Ishii <ishii@postgresql.org>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Tatsuo Ishii <ishii@postgresql.org>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Tatsuo Ishii <ishii@postgresql.org>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Tatsuo Ishii <ishii@postgresql.org>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Tatsuo Ishii <ishii@postgresql.org>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Tatsuo Ishii <ishii@postgresql.org>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Tatsuo Ishii <ishii@postgresql.org>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <fabien.coelho@mines-paristech.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Tatsuo Ishii <ishii@postgresql.org>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Tatsuo Ishii <ishii@postgresql.org>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Tatsuo Ishii <ishii@postgresql.org>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Greg Smith <greg@2ndQuadrant.com>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) David Fetter <david@fetter.org>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Tatsuo Ishii <ishii@postgresql.org>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Tatsuo Ishii <ishii@postgresql.org>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) Fabien COELHO <coelho@cri.ensmp.fr>
Re: [PATCH] pgbench --throttle (submission 4) Michael Paquier <michael.paquier@gmail.com>

> number of transactions actually processed: 301921

Just a thought before spending too much time on this subtle issue.

The patch worked reasonnably for 301900 transactions in your above run, 
and the few last ones, less than the number of clients, show strange 
latency figures which suggest that something is amiss in some corner case 
when pgbench is stopping. However, the point of pgbench is to test a 
steady state, not to achieve the cleanest stop at the end of a run.

So my question is: should this issue be a blocker wrt to the feature?

-- 
Fabien.


В списке pgsql-hackers по дате отправления
От: Fabien COELHO
Дата:
От: Jan Wieck
Дата:
FAQ