| From: | David Gould <daveg(at)sonic(dot)net> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | sigutis(at)gmail(dot)com |
| Subject: | Re: BUG #15003: pg_terminate_backend does not work |
| Date: | 2018-01-11 11:20:56 |
| Message-ID: | 20180111032056.28a184dd@engels |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Thu, 11 Jan 2018 08:43:27 +0000
PG Bug reporting form <noreply(at)postgresql(dot)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(at)sonic(dot)net
If simplicity worked, the world would be overrun with insects.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Gould | 2018-01-11 12:17:57 | Re: BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. |
| Previous Message | PG Bug reporting form | 2018-01-11 11:12:54 | BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. |