Re: BUG #15003: pg_terminate_backend does not work - Mailing list pgsql-bugs

From David Gould
Subject Re: BUG #15003: pg_terminate_backend does not work
Date
Msg-id 20180111032056.28a184dd@engels
Whole thread Raw
In response to BUG #15003: pg_terminate_backend does not work  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
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.


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15005: ANALYZE can make pg_class.reltuples inaccurate.
Next
From: David Gould
Date:
Subject: Re: BUG #15005: ANALYZE can make pg_class.reltuples inaccurate.