Re: Progress indication prototype
От | Greg Stark |
---|---|
Тема | Re: Progress indication prototype |
Дата | |
Msg-id | AANLkTi=jRFk313mR=Q0poWanJWtOwSwSo=MaDxJsGtvO@mail.gmail.com обсуждение исходный текст |
Ответ на | Progress indication prototype (Peter Eisentraut <peter_e@gmx.net>) |
Ответы |
Re: Progress indication prototype
|
Список | pgsql-hackers |
<p>(Sorry for top posting and for any typos -- typing on my phone)<p>In my earlier patch to do progress indicators for arbitrarySQL queries I had envisioned a setup similar to how we handle query cancellation. Psql could support a key likeSIGINFO which would make it request an update. Clients like pgadmin would either do that periodically or set some gucor protocol option to request periodic updates in advance.<p>greg<p><blockquote type="cite">On 17 Aug 2010 19:07, "StephenFrost" <<a href="mailto:sfrost@snowman.net">sfrost@snowman.net</a>> wrote:<br type="attribution" /><p><fontcolor="#500050">* Alex Hunsaker (<a href="mailto:badalex@gmail.com">badalex@gmail.com</a>) wrote:<br /> > OnTue, Aug 17, 2010 at 06:31, Stephen Frost <sfrost@sn...</font>If it was configurable via \set and I could drop it inmy .psqlrc, and<br /> it knew not to only do it after a few seconds (otherwise it'd be far too<br /> much)...<br /><br/> I don't like how the backend would have to send something NOTICE-like, I<br /> had originally been thinking "gee,it'd be nice if psql could query<br /> pg_stat while doing something else", but that's not really possible...<br />So, I guess NOTICE-like messages would work, if the backend could be<br /> taught to do it.<br /><br /> Thanks,<br/><font color="#888888"><br /> Stephen<br /></font><br />-----BEGIN PGP SIGNATURE-----<br /> Version:GnuPG v1.4.9 (GNU/Linux)<br /><br /> iEYEARECAAYFAkxqzFwACgkQrzgMPqB3kijVbACfWkUc/A5+6NaViTf8f9yrN/vT<br /> Y3AAn1eDvj4meqxlr05r0L51j+OypNqs<br/> =f+ya<br /> -----END PGP SIGNATURE-----<br /><br /></blockquote>
В списке pgsql-hackers по дате отправления: