Re: Query progress indication - an implementation

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

On Mon, Jun 29, 2009 at 3:47 AM, Scara Maccai<m_lists(at)yahoo(dot)it> wrote:
>
> Is anyone interested in such a progress indicator???
>

I'm relatively new to Postgres and just starting to look at starting
to look at what we might do with it for handling large genomic
datasets. I've used Toad for Oracle to have a look at whats going on
inside long running Oracle queries. Knowing that a particular step is
doing a particular activity is useful for diagnostics as well as being
assured that you actually are making forward progress. 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.

--
Peter Hunsberger

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2009-06-29 14:15:43 Re: Query progress indication - an implementation
Previous Message Lars Kanis 2009-06-29 13:14:27 [PATCH] user mapping extension to pg_ident.conf