Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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.




      

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group