Re: [HACKERS] subscription worker doesn't start immediately on eabled - Mailing list pgsql-hackers

From Petr Jelinek
Subject Re: [HACKERS] subscription worker doesn't start immediately on eabled
Date
Msg-id 222fb4e5-acb8-cc4d-fb7b-3d12740512b4@2ndquadrant.com
Whole thread Raw
In response to [HACKERS] subscription worker doesn't start immediately on eabled  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
List pgsql-hackers
On 06/04/17 14:24, Kyotaro HORIGUCHI wrote:
> Hello. I found dubious behavior while playing with logical
> replication.
> 
> When we disable a subscription, replication worker immediately stops.
> 
> =# ALTER SUBSCRIPTION s1 DISABLE;
> 
> On the other hand even if we enable a subscription, worker
> doesn't start immediately. It takes 3 minutes in the worst
> case. (DEFAULT_NAPTIME_PER_CYCLE)
> 
> The attached patch wakes up launcher when a subscription is
> enabled. This fails when a subscription is enabled immedaitely
> after disabling but it won't be a matter.
> 

Makes sense, I think this got lost in all the refactoring, thanks.

--  Petr Jelinek                  http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: [HACKERS] Faster methods for getting SPI results (460%improvement)
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] pg_background contrib module proposal