-----Original Message-----
From: pgsq...@postgresql.org
[mailto:pgsq...@postgresql.org] On Behalf Of Greg Stark
Sent: 19 July 2006 10:19
To: Tom Lane
Cc: Neil Conway; Gregory Stark; pgsq...@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.