RE: wake up logical workers after ALTER SUBSCRIPTION - Mailing list pgsql-hackers

From Hayato Kuroda (Fujitsu)
Subject RE: wake up logical workers after ALTER SUBSCRIPTION
Date
Msg-id TYAPR01MB5866233C60501EA7CBFE4385F50D9@TYAPR01MB5866.jpnprd01.prod.outlook.com
Whole thread Raw
In response to wake up logical workers after ALTER SUBSCRIPTION  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: wake up logical workers after ALTER SUBSCRIPTION
List pgsql-hackers
Hi Nathan,

I have done almost same thing locally for [1], but I thought your code seemed better.

Just One comment: IIUC the statement "ALTER SUBSCRIPTION" can be executed
inside the transaction. So if two subscriptions are altered in the same
transaction, only one of them will awake. Is it expected behavior?

I think we can hold a suboid list and record oids when the subscription are
altered, and then the backend process can consume all of list cells at the end of
the transaction.

How do you think?

[1]: https://commitfest.postgresql.org/40/3581/

Best Regards,
Hayato Kuroda
FUJITSU LIMITED




pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: perform_spin_delay() vs wait events
Next
From: Amit Kapila
Date:
Subject: Re: [BUG] FailedAssertion in SnapBuildPurgeOlderTxn