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.96) (envelope-from ) id 1vlMkz-00ARFk-2Q for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Jan 2026 07:48:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vlMky-0078tC-2c for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Jan 2026 07:48:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vlMky-0078sy-1g for pgsql-hackers@lists.postgresql.org; Thu, 29 Jan 2026 07:48:00 +0000 Received: from mail-oo1-xc32.google.com ([2607:f8b0:4864:20::c32]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vlMkw-002siJ-1F for pgsql-hackers@lists.postgresql.org; Thu, 29 Jan 2026 07:47:59 +0000 Received: by mail-oo1-xc32.google.com with SMTP id 006d021491bc7-662feac8228so402204eaf.3 for ; Wed, 28 Jan 2026 23:47:59 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1769672878; cv=none; d=google.com; s=arc-20240605; b=EiQN8DiBG4tqJBYW3nMycDyIL5stBSBPORHvrSbD3TymHeXbYD8ilnVLWzdReuyVLv OXMwIw3Ph1re0w6HXd1OxPp9ROTQW5t8JthCf4V4glQfylkUZ4bihhnMPBT96+LcoXvN cvbvYCDzBTg3lg92sBkUZdrleSeyJnjaiLietjc6qsxV1YJnLzvzEkyYk/XitUUXY4x0 bWE38Ron00WMK83NK07B7mf/Pkeq3tw5vFBczH421oc4KHgsO8vRgjXv38qlMvkUhN0Y e4cjSerAefskFKEhARs2gHMPdBIXK2nni79PRU0R2/nJE6FNX9H4aF/5EjlZfTjn6loL ODQg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=g01NLUJoafurHTE1BesvL5UCLCl/xkv/lkkVI0FZ9/E=; fh=1H3QQ5CYks/wXb79raLf7kwdDb7HwpK/hnpxLsBlDAA=; b=d9SCxenqGWUD408NcLB06oZKTuJpqmBlJr16HGS+P36EaMt1vEjpZ/31xMva8lj20N kCZQETfcultYZRvSlwC56lWj3WxAUVa5VDAaX5NHX+edTUOSGCkdusT9Q8m23ztAHWCj A8v5CrIScrxlfueNxXEOZhzo2HNDiUeovPORERdntdLEp/C6wI4LuPhdgdNz8eDGDHZT R0c12hvvOz/Fefy86YnfpbhQTrq0mb4DMg8gcfWG0FDlcHVH6DSP4xH6bifGK7jDOqty ibiKdLX5V1Ky50Gw15h6iGL2axTWEZ6lvGslXvmoqp9gpwaZaSuPbTYEB/M033bDXPdx /joQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1769672878; x=1770277678; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=g01NLUJoafurHTE1BesvL5UCLCl/xkv/lkkVI0FZ9/E=; b=lB2ZBjs8LSuBpDanIwvQiDEj6rwXu3rSPs5GUpE/xbM8Vw0SzQl4yrtjcqabtS4pJm U/cHjP2+dxBPfc9L3A7WVXE0zOkVWxhgxBe1H7QwJK3cAGTHKk5a9InaWfpACyO81BFp QO2U9keyQUyfOrXaEqU6ihqEk69mYF410GI8DMzd5KAeqRMI/VmH8u3sdBHpn+/yFCAy 0785xkWX2U4jsEI7sk8CWVBVzhBj5HoZ2drR8lElC+GuSrMigaVM7RL5G3wf1samqhu3 4lJBvlXyX5pNNQBs3VmbSqgMHsLfVlH76MppREi93CizI6K9k8fqB6ZXCOwaRuJoCvyq 5DDw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1769672878; x=1770277678; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=g01NLUJoafurHTE1BesvL5UCLCl/xkv/lkkVI0FZ9/E=; b=LHI8sw2VYqIPoDZnduVJlC8hew/ZcaY/JMkl6j/0ryDlHBDpT+HTtIn6Wj5ZRTzuVi TuMa0TT5O1viHbwWsId/iWAYCaDf6OWxiXpQptYq5R/2gzSN41YycOrItL1YxI6KPZWh lwq7gWv6Th06mM1m9t/F6yWYHbWZXre++cMcxte1pi5+vzc/CF4xMXcJ3xoEw4nKFzTf gtnnFQcUN3RrGCCZ/VxdM96epIFRg5eyZMMe6anV00uN4fKrcd6aAMGWWp5w/oABP/Xz Rbv4KQ4B9prsEgsw5GvF9Q2x8PXnDkLdSZwtbjn6aJn8FSUJR7tuHcxXLj4dRtBfXVfb 35Ag== X-Forwarded-Encrypted: i=1; AJvYcCUQrwmsvvpPrgNbXviY0CNN06v9/A8uXslfw2ffhRq5RrN2BpWyySt8Fj5Sk0joBkzPjE0b2R6ncS8bis3O@lists.postgresql.org X-Gm-Message-State: AOJu0YxdE7TijF8ffgmNAjYIHbQTr6QfQ4xLz+BXIE6Gb+pe+QUnz0fv ItpdFuwoU0H/pK3fFkWeLOQGcxKwHLT7+vSfURuO2DzBNW47zNHxywwEd0Q1wo9QTaanYRnNFKz QTxcVFdudbSSYpLvakAYCD/5edok63zc= X-Gm-Gg: AZuq6aId7PxrCMvEsAd6VPCYv7j8eNMhG6cIvErnghXQr1z1+/X0g60uTdhMZm2ia6P wTRsJIiOSyp5ZAyvxziAfJO0BOAQYha+/dahXdOcNQoYBoohbVQY3O1NIHbXXXglTwEAaw08L4a MiJXBjxOWeST2KfggW8Bah0mmKcKGWgqAo22J8suzZgypAqcg1ww3mDCezK+4RGDqhrjXmG8bPq JZ1GRFqCQvU+kLkn7cJ46xNhSvB2V0Xe0sjHy3h/4j+Ug3k2QPlXKZWNTEfvHFgFPauxCS2BWvK Exj/b6jgWyHXD72m2O3vJ1UQ4/3n751qu8tBG+TPgvI2yoHH9gcjzoDvPeMo3KrIzY7/tA== X-Received: by 2002:a05:6820:20f:b0:663:3e1:e871 with SMTP id 006d021491bc7-66303e1f14cmr1305182eaf.56.1769672878353; Wed, 28 Jan 2026 23:47:58 -0800 (PST) MIME-Version: 1.0 References: <202601011659.ikh4ku4p3ovb@alvherre.pgsql> In-Reply-To: From: Alexander Korotkov Date: Thu, 29 Jan 2026 09:47:46 +0200 X-Gm-Features: AZwV_Qiu3cI1fM5eUFF61LlCKkETI-rXDGjXKiuXgXz_gyfz0xiuqsKDMxmav7E Message-ID: Subject: Re: Implement waiting for wal lsn replay: reloaded To: Xuneng Zhou Cc: Heikki Linnakangas , Peter Eisentraut , Andres Freund , Thomas Munro , =?UTF-8?Q?=C3=81lvaro_Herrera?= , Chao Li , pgsql-hackers , Michael Paquier , jian he , Tomas Vondra , Yura Sokolov Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Jan 27, 2026 at 3:14=E2=80=AFAM Xuneng Zhou = wrote: > Heikki spotted a misplaced wake-up call for replay waiters in > PerformWalRecovery. He suggested that the WaitLSNWakeup needs to be > invoked immediately after wal record is applied to avoid the potential > missed wake-ups when recovery stops/pauses/promotes. It makes sense to > me. Please check the attached patch to fix that. Pushed, thank you! ------ Regards, Alexander Korotkov Supabase