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 1wSNgG-00397C-0X for pgsql-hackers@arkaria.postgresql.org; Wed, 27 May 2026 23:28:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wSNgE-00A8VF-0S for pgsql-hackers@arkaria.postgresql.org; Wed, 27 May 2026 23:28:55 +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.96) (envelope-from ) id 1wSNgD-00A8V7-2l for pgsql-hackers@lists.postgresql.org; Wed, 27 May 2026 23:28:54 +0000 Received: from mail-pj1-x1036.google.com ([2607:f8b0:4864:20::1036]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wSNgC-00000001lgu-2v6u for pgsql-hackers@lists.postgresql.org; Wed, 27 May 2026 23:28:54 +0000 Received: by mail-pj1-x1036.google.com with SMTP id 98e67ed59e1d1-36b900f350fso29961a91.0 for ; Wed, 27 May 2026 16:28:52 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779924530; cv=none; d=google.com; s=arc-20240605; b=Mz3kwjwTHu+2shJGPwtZa/ss3N/CsU+0z2y7oQJbPrymTutxVX5BQwN71kvQUPv769 PmlGlkDV79CXilei32DqiMWWoDm3XMrg9dU95X/HQVv39Jt3qsybdYH4QFHnCQIKCcIf GtyIj78v4R4cMMjSP4SXI+WeD4P+4CEXgd3DM/O3CraROsgrfZDtCs1zKRKbEZGLyv+y xqHo6v5xbmm1mA+aMrwOTPT1BCg6l7Bn+a00a6zmZVGG/7/vsq/sn82lP0HMYQx5/kzr NyESTHMtW8m2rzWgQRvrGQDrXo/fWi8bLl95fr2weeMHvlyjfejzFe27YrbbOAXdXjTG Q7Yg== 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=jVoIbkI62CnDbwXAZ4fT69ZbAC3YyQo5lacffyyqInU=; fh=Lew3xJLHwG/9reaq+h8sOHvEmzTYE+coRk/C2Mds+p8=; b=c2b2CNriU8aqu6wyNTSDph1B0v9x+cbvAeeCu18XMgNjoQQIq4wrbz1aCKC3t9R9L6 vicpP/aABI1c6+0dTkpWg+wedCx9rJ4u0LG41qwp6Mc4n89WBPrZ1vd2EQK9dlTzjvE2 gDSwdjsLhkdgUvN2bkIVI2XJdTbBVxzrkEjSqGbODFSVDMFfnrf/oYZON1J/SK/EnIgq qdhalMP9E7fdErkGTBFc+IvVfDs4lFXlCIbT1bzw53E0/4OH92xmofACxvFuXfc+Yvf3 8wJ2c/ay2AlGKvUZCmafzktqlleyEY5XVzphGi2wrMFab04YUl4u8SW3OiGCqL6/SxgO xYxg==; 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=20251104; t=1779924530; x=1780529330; 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=jVoIbkI62CnDbwXAZ4fT69ZbAC3YyQo5lacffyyqInU=; b=aZ8qkfX/QXo1D5wO4x7/0FVVmJGrGLbk1h6FsWOAavboIklz7g8yMjVbX1YpzSoYFs u53nz/S4EYNrx+QIi8Pf3ZUt/wGF5Iv/HS2OpU3ytJWY9AQUddFkRC1kZVXd71DHFKl5 hmZ1b4jgJEIWXsa8QIggHO404k6ZJZdxP4GULaW87cSsSgtJV9sjJFx1vbB+X7sABOyV tms46p6EMerihuBfXuHwjTRghIRlE2+Tol/WnAEHA+O2O1AA/AHpQCX+uGyYEKxmUqOx MUYlfhE7He9QmlK3WG24AAk5hEz63x+cpQiJBVNy35VkzyQbM5xMECwt9v9FkuFtKuDE M5fQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779924530; x=1780529330; 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=jVoIbkI62CnDbwXAZ4fT69ZbAC3YyQo5lacffyyqInU=; b=FmRQkM9YhVGwxXbE/MMIgT3ddpUX2uFdMsqARTGb7oB+sBAUhrkWGECkqjdQlssK/+ voufi4zO8697PhOap5T6oiJ4pFeq+YtPHRaDCk/2ini8dyFb666cRh14VTSXMzpwzBGb FQuUaHE3ezSb3GtqdBMBs+A+8+1KGlVMHTjWOO5332RcY7Ip97sVNzh6faVuw4ef9Uak iH7OsO9xo4B1YlQ2+kwHTlp4tjM72fZMMsa04xwAEJb66F5So8SxnfLkzhYVDALY9+uB UwkzYe9PSNyu4xZ/eY/0yDCZKOtP4wql0IGey2TRQ9yJx6ua9bOk2gMP/aSfQx/WeDpm xHYA== X-Forwarded-Encrypted: i=1; AFNElJ8PuyxmEtLIe9CjmGq36WnmMhMMTWRbOJ7oA4cx/6rXo4SExY144ySsFQcsvaZZ48yXVVLV1a7yAKBOfISQ@lists.postgresql.org X-Gm-Message-State: AOJu0Yzk3OLEFX8x8h3tw19QO+wklttqckAxS1FZpDYTeaZOWL5HI+sW /NaO4lJNfJQKg5fRPDN3fNViOAxvK9S+7xD1hTfQozu8tJPX++0CbMKaOCLHZS+yUc5F5576GkX UfXn6A34H6ofOziEc8qcLQ6i4VXyp/Ek= X-Gm-Gg: Acq92OFTGE3Q8ztM1DVh58Cn9a7I+/IypG+ZWcUTShd/mWUSyn1Ug9oRMSgDcDG/FD3 jv9Xi9xircaokPMTkX5v4PBWy4NGwzJidzhjNRUJp8AI2VRmA/sBImj28LnNuyjmok0/H79hQn+ LwBxOT2GnDyfPY2T6yYBcl7oiP1C4nnMYeMYE9UtuAPMYmxLEpHjUJ4OpsVq3pNGxn4IRtIquq8 8FQN5rkhTjrCqpGRXJTVCjgn/8CxfLH2E7fF9yOlqjDGByNvTc3ar3oyGnuWqA1MQ0dMpdUJ4Sm wMOwvN3UK/NUAnJMLVZduNfO8PsAG1AOs5Lt4IJfuDKZuVMvn9bdHpUgMGmiRw== X-Received: by 2002:a05:6a20:d80c:b0:3a3:240d:4fcb with SMTP id adf61e73a8af0-3b328d0aef2mr23442887637.13.1779924530388; Wed, 27 May 2026 16:28:50 -0700 (PDT) MIME-Version: 1.0 References: <4358bd85-f6b4-4da6-9909-74428fe3c8f7@gmail.com> <2a199ba7-1d18-438a-847e-5241b7dac514@gmail.com> <18c0f20b-c79a-4358-8d95-cba8819de9f5@gmail.com> In-Reply-To: From: Masahiko Sawada Date: Wed, 27 May 2026 16:28:13 -0700 X-Gm-Features: AVHnY4J32Dn7N61SQaML-Fc0JghaGKFC7uKKoyjlTxLPelqEwQGeszG7uJIvJV4 Message-ID: Subject: Re: Startup process deadlock: WaitForProcSignalBarriers vs aux process To: Matthias van de Meent Cc: Alexander Lakhin , Andres Freund , Thomas Munro , PostgreSQL Hackers , Heikki Linnakangas , Andrey Borodin 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 Fri, May 22, 2026 at 4:26=E2=80=AFPM Matthias van de Meent wrote: > > On Thu, 14 May 2026 at 14:48, Masahiko Sawada wro= te: > > > > While reviewing the patches, I realized that it would be better to use > > pg_atomic_write_membarrier_u32() instead of pg_atomic_write_u32() + > > pg_memory_barrier() where available. I've updated the patch for master > > and 18, and slightly commit messages. > > LGTM, thanks for getting this fixed! > Pushed the fix down to v15. Thank you for reviewing the patches! Regards, --=20 Masahiko Sawada Amazon Web Services: https://aws.amazon.com