On Mon, Oct 19, 2020 at 2:37 PM tsunakawa.takay@fujitsu.com
<tsunakawa.takay@fujitsu.com> wrote:
>
> Really. I thought we were talking about canceling commits with Ctrl + C as you referred, right? I couldn't imagine,
inproduction environments where many sessions are running transactions concurrently, how the user (DBA) wants and can
canceleach stuck session during commit one by one with Ctrl + C by hand. I haven't seen such a feature exist or been
consideredcrucial that enables the user (administrator) to cancel running processing with Ctrl + C from the side.
Using pg_cancel_backend() and pg_terminate_backend() a DBA can cancel
running query from any backend or terminate a backend. For either to
work the backend needs to be interruptible. IIRC, Robert had made an
effort to make postgres_fdw interruptible few years back.
--
Best Wishes,
Ashutosh Bapat