Re: proposal 9.4. Explain on signal

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Em 16-05-2013 07:52, Pavel Stehule escreveu:
> 2013/5/16 Thom Brown <thom(at)linux(dot)com>:
>> On 16 May 2013 11:09, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
>> wrote:
>>> Hello
>>>
>>> I proposed a some months log plans of cancelled queries
>>> http://www.postgresql.org/message-id/CAFj8pRA-DuzkmDtu52CiUgb0P7TVri_B8LtjMJfWcnr1LPts6w@mail.gmail.com
>>>
>>
>>
>>>
What a neat idea. So the original plan of EXPLAINing cancelled
>> queries... does this cater for that? Can cancelled queries
>> automatically invoke the EXPLAIN functionality as part of this
>> feature?
>>
>
> I would to get EXPLAIN of long queries without waiting on end.
>
> So it is possible for manual cancelation (not for timeout)
>
> SELECT pg_explain_backend(xx); SELECT pg_cancel_backend(xx);

BTOH, we could provide a pg_cancel_backend(pid, boolean)
so when that boolean is true it will do that job. Particularly
I'm not a fan of this kind of boolean flag and appreciate
the two function above, so +1.

BTW, if somebody wants an explain-and-cancel behavior
he could creates a function and call both function
pg_(explain|cancel)_backend(..) consecutively.

[]s
- --
Dickson S. Guedes
mail/xmpp: guedes(at)guedesoft(dot)net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
http://github.net/guedes - twitter: @guediz
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJRl3thAAoJEBa5zL7BI5C74voIAJ0PhUlnRz/MEyS3ckeQPNEp
6ZT1f4zddkP+oC626+uv9Gb34lokg6Y+5JrMYFcKm3Pq+3mIiKaq2yY08GW3pkBk
7zbvTSKCQdNO7PprhR9EUjyJ5IZrwkG8nNZJm+98ohkv5dZiHqLl0ovGJGg2yeLd
kkRTmQOOmPalBado1i8SARaEq6apelpmPETl7fkutXAMhq4MSfsB0x0ZofT9/RDA
H18/kssql7BVtm7Rw9uJJe37vnpJJgrsjf8qHzJFZcyhxDjMDHAyzViacfKtd8Mv
WPbZcVTQ5jHHmyReIPECAPseQ/m9eV8gM66X2elO4MDyCZ0hB9xaqZCixnx1844=
=AL0R
-----END PGP SIGNATURE-----