Re: Query progress indication - an implementation

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Query progress indication - an implementation
Дата
Msg-id 200906290953.25677.peter_e@gmx.net
обсуждение исходный текст
Ответ на Re: Query progress indication - an implementation  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Sunday 28 June 2009 20:38:59 Robert Haas wrote:
> The only other use case I can think of for functionality of this type
> is some kind of dashboard view on a system with very long-running
> queries, where you want to see how far you have yet to go on each one
> (maybe to approximate when you can submit the next one) without having
> detailed knowledge of how expensive each individual query was project
> to be.  But that's a pretty narrow use case, and I'm not sure it
> really justifies the overhead of instrumenting every query in this
> way.

Well, progress information is probably only going to be useful for long-
running processes anyway, and then only when the admin is too bored and 
wonders what he can usefully cancel.  So it seems import to figure out exactly 
when to turn this on and when not to without causing too much overhead 
elsewhere.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Itagaki Takahiro
Дата:
Сообщение: Re: query cancel issues in contrib/dblink
Следующее
От: Scara Maccai
Дата:
Сообщение: Re: Query progress indication - an implementation