Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uKmjR-00BNTa-Pz for pgsql-bugs@arkaria.postgresql.org; Thu, 29 May 2025 23:32:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uKmjQ-00DLCY-GQ for pgsql-bugs@arkaria.postgresql.org; Thu, 29 May 2025 23:32:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uKmjQ-00DL6o-8S for pgsql-bugs@lists.postgresql.org; Thu, 29 May 2025 23:32:16 +0000 Received: from fhigh-a5-smtp.messagingengine.com ([103.168.172.156]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uKmjN-000nST-0y for pgsql-bugs@lists.postgresql.org; Thu, 29 May 2025 23:32:15 +0000 Received: from phl-compute-12.internal (phl-compute-12.phl.internal [10.202.2.52]) by mailfhigh.phl.internal (Postfix) with ESMTP id 12A3E114010F; Thu, 29 May 2025 19:32:12 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-12.internal (MEProxy); Thu, 29 May 2025 19:32:12 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm1; t=1748561532; x=1748647932; bh=ftiKQUJxAo yEQ4+Tr/OLCJ8unMDK35IdlVNgmxx3YeI=; b=h0d7o13G6UU/4mL7+X3Y3I+hrG C0z69R20jbVAmG5j6+JS35mqm3JOYfIqVVq+WTYSzm3eWlqKBMXbmdZBjKaHjBE7 hVwfpuuLxsey3s54XFgreuXXdTpxBb5yaPCz7W5l/OajczmFlOhOREObzSceMXHv oXTkTEJ+JJqWktrT/mpfvtKXCIqABwBwN9mrJ1K1kzesGNo6egmONMge9JbhT2Zr Lt3hllQy2VTFeCBU5i8jtu3XSH83qvfcPfT3DzewNY9sLxU4tVB1FtyRuwTbU2ng RyDjg61YpfP1M+5Uuq/dbt5+U03uVh0B7SUpHmp/T2Y7u7xAtFkZxxoH4i6A== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t= 1748561532; x=1748647932; bh=ftiKQUJxAoyEQ4+Tr/OLCJ8unMDK35IdlVN gmxx3YeI=; b=AclPZIelTV2wlFzrL31RQme5IkkJRSaNOkTPlcL8m/vck8w7zaT UbfzL+8FdK229UlBP3T1pyYfuPPscIvHnO7/ysyXALWtGSpnO4oTshMklj/1M/tb 4H3hMqt5H5leLOf8sgAj0z2hBp5b8Bgu/rqBMe9wJkRUcFVBu4divfrx8vABKJ/H AHu5xYdsyiOvpk8H7Sq0E+gtOIo5eYbNbLgSlfHLQiYGjjm80cEYJsdXSt/T1Zha vOIkUWpzOMop90SWCWzIkVx8y6mQU0iMjlGmGLxzgwiv64Caud9k2X/08AzZEB2h QOdg/rFcupLWsbV4/PP3Qjw4zy+rVFiWRgw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtddtgddvjeegieculddtuddrgeefvddrtd dtmdcutefuodetggdotefrodftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggft fghnshhusghstghrihgsvgdpuffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftd dtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfghrlhcuvffnffculdejtddm necujfgurhepfffhvfevuffkfhggtggujgesghdtreertddtvdenucfhrhhomhepofhitg hhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeen ucggtffrrghtthgvrhhnpeetleeifedufffhhfdtteelgeeggeffhfekueevteeigfduud evudetgfegiedvjeenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhl fhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiipdhnsggprhgtphhtthhope ehpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehithhsrghjihhnsehgmhgrihhl rdgtohhmpdhrtghpthhtoheprgdrmhgrkhhhmhhuthhovhesphhoshhtghhrvghsphhroh drrhhupdhrtghpthhtohepsggvrhhtrhgrnhguughrohhuvhhothdrphhgsehgmhgrihhl rdgtohhmpdhrtghpthhtohepshhhvhgvthgrrdhmrghlihhksehgmhgrihhlrdgtohhmpd hrtghpthhtohepphhgshhqlhdqsghughhssehlihhsthhsrdhpohhsthhgrhgvshhqlhdr ohhrgh X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 29 May 2025 19:32:09 -0400 (EDT) Date: Fri, 30 May 2025 08:32:05 +0900 From: Michael Paquier To: Ajin Cherian Cc: Alexey Makhmutov , Bertrand Drouvot , shveta malik , pgsql-bugs@lists.postgresql.org Subject: Re: Standby server with cascade logical replication could not be properly stopped under load Message-ID: References: <52138028-7246-421c-9161-4fa108b88070@postgrespro.ru> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="S8o5T04dS8VP4wV1" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --S8o5T04dS8VP4wV1 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, May 29, 2025 at 08:28:01PM +1000, Ajin Cherian wrote: > I think this new fix is much better and cleaner. A suggestion for the > comment: > "For cascading logical WAL senders, we use the replay LSN instead of the > flush LSN, since logical decoding on a standby only processes WAL that has > been replayed. This distinction becomes particularly important during > shutdown, as new WAL is no longer replayed and the last replayed LSN marks > the furthest point up to which decoding can proceed." Yes, that sounds better than my previous suggestion. Thanks. -- Michael --S8o5T04dS8VP4wV1 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmg47nUACgkQnvQgOdby QH10cBAApFgtVUSNGzetXbLFbDyKKo7HAhy9IUy590wckswSCgvc8ITR45qJawUW 6kDboBbjYqueumRrjpOp/XPcN6EpOmTEJvNSVsx/EEnThwkmc9UrtZwd9iPpSqk1 39iWUmXDsRJBZsNe/3OAr7KW/dYsJpMjOYt4sQnVE8WAuArsqbzp8B4DpCnO6TJA zZPR1qYOyVc9paaEg/Rk9aNAKxzkwWAF/qCUK6NYKXd6LVoTgw+8+WexhEcdsFa4 UD/X1g07TIt6SMYQEiNtB5FPoC3yeqjJTqqrzwwOdtiXW1tl44HE4kS/e7FV8FFX ZY55Kyi8ZVN0QH3hE3B05hQ0SKxek2zGlynq57bFM34k4lx27Imu2wGeQnyyq/hg 6SABNpwMGf4U6O+hQTtBtKmY9SA73GLu7y0zB/P3qusfjgy+VRme+rZrfYRf/w5S fzV21y+UL+L0zVuq1e49gsmBq24LAk8CnwEE9K461WMm5t/AAm8zWLDsKw36oMaY xAVA3WIJKSAD6bjkxC81qLz4P7Fra8XZw1Xd+Qi5p9w1Kjj7zuDUzpgVZPxoam2u HwpcMOOzQq2DJXomkkLG47MBaUpNfhNDzXxfqrKoF+i9cyJUuaKFcfPqRuDyfLwL CviGrLGDftWPjgNw9SHf4ammQ/R8qrDrSvRCB0M72vYmhD1RcM4= =RP8h -----END PGP SIGNATURE----- --S8o5T04dS8VP4wV1--