| From: | Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | subscription worker doesn't start immediately on eabled |
| Date: | 2017-04-06 12:24:41 |
| Message-ID: | 20170406.212441.177025736.horiguchi.kyotaro@lab.ntt.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
regards,
--
Kyotaro Horiguchi
NTT Open Source Software Center
| Attachment | Content-Type | Size |
|---|---|---|
| enable_sub_starts_worker.patch | text/x-patch | 475 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2017-04-06 12:45:08 | Re: identity columns |
| Previous Message | Aleksander Alekseev | 2017-04-06 12:21:17 | Re: [PATCH] Remove unused argument in btree_xlog_split |