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 1wPkiI-0010CK-0I for pgsql-hackers@arkaria.postgresql.org; Wed, 20 May 2026 17:28:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wPkiE-0088jr-2G for pgsql-hackers@arkaria.postgresql.org; Wed, 20 May 2026 17:28:07 +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 1wPkiE-0088ji-15 for pgsql-hackers@lists.postgresql.org; Wed, 20 May 2026 17:28:07 +0000 Received: from mail-yx1-xb134.google.com ([2607:f8b0:4864:20::b134]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wPkiC-00000000WEW-3WY4 for pgsql-hackers@postgresql.org; Wed, 20 May 2026 17:28:06 +0000 Received: by mail-yx1-xb134.google.com with SMTP id 956f58d0204a3-65d071aac6eso4345090d50.0 for ; Wed, 20 May 2026 10:28:05 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779298083; cv=none; d=google.com; s=arc-20240605; b=NsBkXiLBv6eGldUDa4KiooM0TxZ4Ol2Q3hLfh7ihYG+C1SFTCdVCHGEQjscSnjIOIg 94rbLjshFrHW1n3Zxrpyrtfclm4JMyh3MKHeIwDIWzEWJ/5qcI9HDeYebAsxsgEVaw/z 0FoWM410+oN/IDNG8qlQubxYRlMhm2qAScecnmco+BxGyG6pVkNqo+Ye0MaQ2HdPtPZ1 N3A7GN9ho7zqgbIlPJWqMqRrm4d+NEzoEsNqsRIUShHcFBou5XJjakUz2hf8Y75htfLL BObTmvFVX7jXTzI3M0wvK1M2D2qipzNNK/Yl1etojCqEZH3ufxVl88Pv8dlHgiCzyuzS 1lPg== 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=M9yuxLt8rMOYj9INakToliDGJRm+Rhlx8eemojvkyL4=; fh=/kK1cEDgD7JKx/Kj+HUrzbzr4mFtKW/RL193pFfWulA=; b=hfttR7MsdbqBEngPCmGfJXkrAvFODiokfhqHLiM1/LJFM+YFrWA9obi+hbBYIicZIt e/CcF7Q6WW6nAUNRY4F1Cq1pWN7ddXRpDUKQ/m+9/vuvlaYjQHqs8Bk/vTXg9ZFeOedY Rnhfcg/ezlYwyJvF5mtBEQKf558FhbyDV2Xv8HXTd3yBXItaVx6UusZhmVRMJhAuBMMw hjDkkyGOTvk7tYPhTV1vcQvlZ0VHMkioDM0Q7QSV962GYvxJk7xPxyNdc8sMQblb/yQt aBYlu7ZvXi8+bjJYVvi+d/H7UY+BczpcNr8zf1e38C0h/MPVPAFui5bOhl+6xLsngpDA RF8g==; darn=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=20251104; t=1779298083; x=1779902883; darn=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=M9yuxLt8rMOYj9INakToliDGJRm+Rhlx8eemojvkyL4=; b=Evp2MazuwRshuLTlUe7BcRZDESdK5blUZbenqTGVpn363bFvMC/w1UItwbhiA/bqoO jcQlI/5GrfR0ZMz1Et1k+jTZ8GMi+nAsB2NoEAY+RURzwuk3h8rNeqydj15ojU239REj OuDE+/6TJvPOnUuQoI358qMCybR/ZvsvZOJ4g2MxpcgRLDer/1YY7mM8V1B3cY1bTvzp o/t5EWW3x3bmwkWQjhJ+QThoGV0+fKE9xgYnCbETVTbT8YaPjZ36ChKH5h4XrCObFXbn GPnp5oWtLKo4+Sm4RxU1bZ3hqpi15BLIdy9l/Oh/VT0AlBdoTJ//1HPHCWIxTec6q0I6 ZVOQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779298083; x=1779902883; 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=M9yuxLt8rMOYj9INakToliDGJRm+Rhlx8eemojvkyL4=; b=D2NlvStAb/CE4iSllHpxbJCsmTj+3EuYBGossFhGjFXe7Shk7sZBtG/XnLclEb3jjp MUWuY/2z0k3ONPCS9B3kGW6Bw6MnbK5AMHocZfdweE6M02WM85S280r1OEA+eQcloH1z KC+Dv3sTm+nEx2/WMEuB/ggomXCGJI1cWg7vTtaIdUIyniZBFVUF43eORvxZEAoT77r/ YyX/tgiEPUYcGy3ziqXGl9JD5bM/oeDMpGY57LR4jE57QBN8+0HaCpVBkFf4JK9n+dpB qTaI72KT+noBjR4s0SHKf52xQBZBomK/uNlO08dbOQScpYRRv5b6k35jabts6dq/93Km q2tw== X-Gm-Message-State: AOJu0YziYZGvLChN+mCNqWsbRZD4Z0SxBCnx93/XR1e2pJtsxpK1WkEA O0wqyzjb2C9R7KmfVZHq1ip4Du9U0kWfMyV3JIY/RoQetORbzkb8UL62e7wdlIOLyBCv/i2zkZI ts0acK6x0LGpUOfmiUigWQ9xKn6pC8YU= X-Gm-Gg: Acq92OG71bDup32QtuQ6yGEDnONAhmKvBXTFEF5Fo/7Czgfk5+limgZwoQrQEUZQWEd q+NG82iuFTSrtHWxfHVc8ktx/bYCg81sBF5AZbSib+oyLCr+k0QKvIZT6QmWt1BOvcfU6K+KS7H rlx/38s3PsXUijv4zl+Ur6jzHcC6mAF/OQJO1AUyY6NWAK9l9McHmBBAzk6A8jUk15fn09Oti9t g0cYPiN37/DeYkZZlIRbdfa9eJOMjXWXiKStwVQeU08XP16pPvFIt9nQbyDH5wyL2SchDOyvpSP N6A4zg== X-Received: by 2002:a05:690e:428b:20b0:65e:14b6:b1c3 with SMTP id 956f58d0204a3-65e226e4b8bmr19736572d50.16.1779298083563; Wed, 20 May 2026 10:28:03 -0700 (PDT) MIME-Version: 1.0 References: <9835b0a4-9121-47ac-9c44-427b8b1a7f1b@app.fastmail.com> In-Reply-To: From: Arseniy Mukhin Date: Wed, 20 May 2026 20:27:51 +0300 X-Gm-Features: AVHnY4LxC3rf_KtxbvOl4WjL4DcdU26w9cXDHhEa9XiMRrh9sxhZiQlSyPEdkZM Message-ID: Subject: Re: [PATCH] Fix LISTEN startup race with direct advancement To: Joel Jacobson Cc: pgsql-hackers 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 Wed, May 20, 2026 at 2:20=E2=80=AFPM Joel Jacobson w= rote: > > On Wed, May 20, 2026, at 04:01, Arseniy Mukhin wrote: > > One point - looks like the 0003 contains the same test as 0001. > > They are similar, but if you look carefully you'll see that they use > different injection points: > > 0001 uses async-notify-before-listen-commit > 0002 uses async-notify-after-listen-commit > Yes, but I meant 0001 and 0003. There are two specs: - async-notify-listen-startup.spec (added in 0001) - async-notify-listen-race.spec (added in 0003) Looks identical, unless I missed something. Best regards, Arseniy Mukhin