Re: Get memory contexts of an arbitrary backend process - Mailing list pgsql-hackers

Since pg_get_target_backend_memory_contexts() waits to dump memory and
it could lead dead lock as below.

   - session1
   BEGIN; TRUNCATE t;

   - session2
   BEGIN; TRUNCATE t; -- wait

   - session1
   SELECT * FROM pg_get_target_backend_memory_contexts(<pid of session 
2>); --wait


Thanks for notifying me, Fujii-san.


Attached v8 patch that prohibited calling the function inside 
transactions.


Regards,

--
Atsushi Torikoshi