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.1307221831340.7300@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>

Hello Greg,

Thanks for the improvement!


I have a small reservation about "finish/end time schedule" in the second 
paragraph, or maybe there is something that I do not understand. There is 
no schedule for finishing anything, only start times are scheduled, so I 
wish the text could avoid suggesting that finish time are scheduled.

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

> finish time schedule

-> start time schedule

> moves forward based on when the client first started, not when 
> the previous transaction ended.


> That approach means that when transactions go past their original 
> scheduled end time, it is possible for later ones to catch up again.

-> That approach means that long transactions can result in later 
transactions to be late with respect to the schedule, while short 
transactions makes it possible for late ones to catch up again.

Would you be ok with that?

-- 
Fabien.


В списке pgsql-hackers по дате отправления
От: Greg Stark
Дата:
От: Alvaro Herrera
Дата:
FAQ