Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oUkpV-0002U3-97 for pgsql-hackers@arkaria.postgresql.org; Sun, 04 Sep 2022 08:18:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oUkpU-00081B-48 for pgsql-hackers@arkaria.postgresql.org; Sun, 04 Sep 2022 08:18:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oUkpT-000812-Qx for pgsql-hackers@lists.postgresql.org; Sun, 04 Sep 2022 08:18:07 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oUkpM-0007sS-Ue for pgsql-hackers@lists.postgresql.org; Sun, 04 Sep 2022 08:18:06 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 0F6CF5C00A1; Sun, 4 Sep 2022 04:18:00 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Sun, 04 Sep 2022 04:18:00 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:reply-to:sender :subject:subject:to:to:x-me-proxy:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1662279480; x=1662365880; bh=p 1Qw4Vv25xE+fFDhElnbXwoufyHpqn1eY3pwWVfbtNA=; b=T1BelH44gWCSIQnwr 2fXi9yO40g9fGpKje6iyCLLEZZ0LGJ6FpyCE9fresWC2b8nMEhzLfAk11Idqs3Z2 +M9ZG3l/5XXdM1cq5Mfa59CzqBF5nuB7loMM9vt6CvfipYROLM/C92qHE2R6heHX FkBJVxk6L0JysdAA0brGLwNQRefacBSxLyraBDkvHzpXo/lj0Ez47LSlae2JDXx5 BhCBtlFj4KrQ2PYdqF9Cibs6ikHoN5oan+PzMEE2Lj/vIPAXrq0yN0EJnJVioYov WtLNzGVJXOg/Pjqfw42zDA2gFuXGtGcfzYZTOJqHxHnC4TwUZTyrkhazgOpKHBDy z65ZQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrvdelgedgtdegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvfevuffkgggtugfgjgesthekredttddtjeenucfhrhhomheptehlvhgr rhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh eqnecuggftrfgrthhtvghrnhepvdektdffudfftdffffehfffhjeejhffgieeuueekjeek fffgudffhfduffffueevnecuffhomhgrihhnpegvnhhtvghrphhrihhsvggusgdrtghomh enucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhv hhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 4 Sep 2022 04:17:59 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 1A52D37D; Sun, 4 Sep 2022 10:18:21 +0200 (CEST) Date: Sun, 4 Sep 2022 10:18:21 +0200 From: Alvaro Herrera To: Amit Kapila , Masahiko Sawada Cc: pgsql-hackers@lists.postgresql.org Subject: Re: pgsql: Add ALTER SUBSCRIPTION ... SKIP. Message-ID: <20220904081821.bck6q2j6gfp3p2im@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2022-Mar-22, Amit Kapila wrote: > Add ALTER SUBSCRIPTION ... SKIP. There are two messages here that seem oddly worded. msgid "start skipping logical replication transaction finished at %X/%X" msgid "done skipping logical replication transaction finished at %X/%X" Two complaints here. First, the phrases "start / finished" and "done / finished" look very strange. It took me a while to realize that "finished" refers to the LSN, not to the skipping operation. Do we ever talk about a transaction "finished at XYZ" as opposed to a transaction whose LSN is XYZ? (This became particularly strange when I realized that the LSN might come from a PREPARE.) Second, "logical replication transaction". Is it not a regular transaction that we happen to be processing via logical replication? I think they should say something like "logical replication starts skipping transaction with LSN %X/%X" "logical replication completed skipping transaction with LSN %X/%X" Other ideas? -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ Officer Krupke, what are we to do? Gee, officer Krupke, Krup you! (West Side Story, "Gee, Officer Krupke")