Re: Query progress indication - an implementation - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Query progress indication - an implementation
Date
Msg-id 603c8f070906291121ye647e9bx16a4779fa8489cce@mail.gmail.com
Whole thread Raw
In response to Re: Query progress indication - an implementation  (m_lists@yahoo.it)
List pgsql-hackers
On Mon, Jun 29, 2009 at 11:15 AM, <m_lists@yahoo.it> wrote:
> So the code that I have right now works "pretty well" for the 10 queries of my project, but I guess won't work for
generalqueries :(
 

I think that's probably right.

>> So, I'm all in favor of what you're trying to conceptually;
>> I just
>> don't like your proposed implementation.
>
> What kind of implementation would you propose?

I don't really have a proposed implementation in mind; I think it's a
hard problem.  That's why I suggested looking at the
EXPLAIN-ANALYZE-in-progress stuff.  By providing a lot more detail, a
human being can take a look at that output and make a judgment about
what's going on.  That's not as easy-to-use as what you're trying to
do, but I suspect it's more useful in practice.  It might be that
after reading a few hundred of those someone could propose some rules
of thumb to estimate the percentage of completion, which we could then
incorporate back into the system.  If not, we lose nothing by
implementing that feature first, since it is independently useful.

> Thank you very much for your comments.

No problem.

...Robert


pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: pre-proposal: permissions made easier
Next
From: Joshua Tolley
Date:
Subject: Re: Query progress indication - an implementation