On Fri, Apr 7, 2023 at 6:55 AM Andres Freund <and...@anarazel.de> wrote: > > On 2023-04-06 12:10:57 +0530, Amit Kapila wrote: > > After this, I think for backends that have active slots, it would > > simply cancel the current query. Will that be sufficient? Because we > > want the backend process should exit and release the slot so that the > > startup process can mark it invalid. > > We don't need them to exit, we just need them to release the slot. Which does > happen when the query is cancelled. Imagine if that weren't the case - if a > cancellation of pg_logical_slot_* wouldn't release the slot, we couldn't call > it again before disconnecting. I also did verify that indeed the slot is > released upon a cancellation. >
makes sense. Thanks for the clarification! -- With Regards, Amit Kapila.
