> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Greg Stark
> Sent: 19 July 2006 10:19
> To: Tom Lane
> Cc: Neil Conway; Gregory Stark; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Progress bar updates
>
> It would be the most practical way for a DBA to monitor an
> application. But
> it's not going to be convenient for clients like pgadmin or
> psql. Even a web
> server may want to, for example, stream ajax code updating a
> progress bar
> until it has results and then stream the ajax to display the
> results. Having
> to get the backend pid before your query and then open a
> second database
> connection to monitor your first connection would be extra
> footwork for
> nothing.
No to mention that we already get occasional complaints about the number
of connections pgAdmin can open (even though it's only one per database
for the main app, plus one per query tool or data editor window).
Regards, Dave.