Обсуждение: [HACKERS] CREATE SUBSCRIPTION uninterruptable
Hi, I've noticed that when creating a subscription, it can't be interrupted. One must wait until it times out, which takes just over 2 minutes. I'm guessing ALTER SUBSCRIPTION would have the same problem. Shouldn't we have an interrupt for this? Thom
On 2/16/17 09:44, Thom Brown wrote: > I've noticed that when creating a subscription, it can't be > interrupted. One must wait until it times out, which takes just over > 2 minutes. I'm guessing ALTER SUBSCRIPTION would have the same > problem. > > Shouldn't we have an interrupt for this? I think this is addressed by these patches: https://commitfest.postgresql.org/13/991/ Please give them a try. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
On 17 February 2017 at 14:14, Peter Eisentraut <peter.eisentraut@2ndquadrant.com> wrote: > On 2/16/17 09:44, Thom Brown wrote: >> I've noticed that when creating a subscription, it can't be >> interrupted. One must wait until it times out, which takes just over >> 2 minutes. I'm guessing ALTER SUBSCRIPTION would have the same >> problem. >> >> Shouldn't we have an interrupt for this? > > I think this is addressed by these patches: > https://commitfest.postgresql.org/13/991/ > > Please give them a try. Okay, I've now tested those patches, and they do indeed fix this problem for me. Thanks Thom