Re: [HACKERS] CREATE SUBSCRIPTION uninterruptable - Mailing list pgsql-hackers

From Thom Brown
Subject Re: [HACKERS] CREATE SUBSCRIPTION uninterruptable
Date
Msg-id CAA-aLv7Jir42WAE+BE736FYYYWsZ7vJvWXsa2WMr1j3GxAfkag@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] CREATE SUBSCRIPTION uninterruptable  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Index corruption with CREATE INDEX CONCURRENTLY
Next
From: "David E. Wheeler"
Date:
Subject: Re: [HACKERS] removing tsearch2