Horton
Menu

Re: Progress indication prototype

Dave Page <dpage@pgadmin.org>

View thread
From: Dave Page <dpage@pgadmin.org>
To: Greg Stark <stark@mit.edu>
Cc: Stephen Frost <sfrost@snowman.net>, pgsql-hackers@postgresql.org, Peter Eisentraut <peter_e@gmx.net>, Alex Hunsaker <badalex@gmail.com>
Date: 2010-08-17T22:29:01Z
Lists: pgsql-hackers 
On Tue, Aug 17, 2010 at 10:53 PM, Greg Stark <stark@mit.edu> wrote:
> (Sorry for top posting and for any typos -- typing on my phone)
>
> In my earlier patch to do progress indicators for arbitrary SQL queries I
> had envisioned a setup similar to how we handle query cancellation. Psql
> could support a key like SIGINFO which would make it request an update.
> Clients like pgadmin would either do that periodically or set some guc or
> protocol option to request periodic updates in advance.

Which is ideal for monitoring your own connection - having the info in
the pg_stat_activity is also valuable for monitoring and system
administration. Both would be ideal :-)

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company