On Thu, 11 Jan 2018 08:43:27 +0000
PG Bug reporting form <noreply@postgresql.org> wrote:
> pg_terminate_backend returns true, but it does not terminates backend.
>
> query - "select sync_devices_run()"
Does the function sync_devices_run() do any sort of IO other than database
queries? pg_terminate_backend() can only terminate queries that are running
postgresql code, so if the function is making a blocking system call for
example, network IO pg_terminate_backend() can't do anything.
-dg
--
David Gould daveg@sonic.net
If simplicity worked, the world would be overrun with insects.