Thread: [HACKERS] CREATE SUBSCRIPTION uninterruptable

[HACKERS] CREATE SUBSCRIPTION uninterruptable

From
Thom Brown
Date:
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



Re: [HACKERS] CREATE SUBSCRIPTION uninterruptable

From
Peter Eisentraut
Date:
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



Re: [HACKERS] CREATE SUBSCRIPTION uninterruptable

From
Thom Brown
Date:
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