Re: Query progress indication - an implementation

From: Scara Maccai <m_lists(at)yahoo(dot)it>
To: Peter Hunsberger <peter(dot)hunsberger(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Query progress indication - an implementation
Date: 2009-06-29 16:20:46
Message-ID: 743255.30235.qm@web24616.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> IMO
> any
> diagnostics you can provide for a low cost are
> useful.  The more
> detail, the better.  "Step 1 of 10" is good, "80%
> complete on step 1
> of 10" is better.  "80% complete on step 1, 10%
> complete on 10 steps"
> is even better.

Well, I guess "Step 1 of 10" would be pretty trivial to implement (given the tree plan, how many branches have finished executing).
This doesn't tell you anything about the remaining time though.
That is: "Step 1 of 10" doesn't mean that you are at 10%, nor that you are at 50%, or 99%. In fact, I'm afraid it doesn't tell you anything...
I don't understand how useful such an implementation would be... "being
assured that you actually are making forward progress"... in which cases could you not be making forward progress?

Still, this won't take much time: if it's needed by someone else I guess it could be easily done.

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2009-06-29 16:52:00 Multi-Dimensional Histograms
Previous Message Tom Lane 2009-06-29 16:12:13 Re: [PATCH] user mapping extension to pg_ident.conf