On Tue, 20 Oct 2020 at 13:23, tsunakawa.ta...@fujitsu.com <tsunakawa.ta...@fujitsu.com> wrote: > > From: Kyotaro Horiguchi <horikyota....@gmail.com> > > I don't think the inability to cancel all session at once cannot be a > > reason not to not to allow operators to cancel a stuck session. > > Yeah, I didn't mean to discount the ability to cancel queries. I just want > to confirm how the user can use the cancellation in practice. I didn't see > how the user can use the cancellation in the FDW framework, so I asked about > it. We have to think about the user's context if we regard canceling commits > as important. >
I think it doesn't matter whether in FDW framework or not. The user normally doesn't care which backend processes connecting to foreign servers. They will attempt to cancel the query like always if they realized that a backend gets stuck. There are surely plenty of users who use query cancellation. Regards, -- Masahiko Sawada http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
