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 1wXbMJ-003MBf-2u for pgsql-hackers@arkaria.postgresql.org; Thu, 11 Jun 2026 09:05:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wXbMI-00FEJ8-29 for pgsql-hackers@arkaria.postgresql.org; Thu, 11 Jun 2026 09:05:54 +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 1wXbMI-00FEJ0-1C for pgsql-hackers@lists.postgresql.org; Thu, 11 Jun 2026 09:05:54 +0000 Received: from mail-pg1-x52c.google.com ([2607:f8b0:4864:20::52c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wXbMG-000000029Zy-1v42 for pgsql-hackers@postgresql.org; Thu, 11 Jun 2026 09:05:53 +0000 Received: by mail-pg1-x52c.google.com with SMTP id 41be03b00d2f7-c8573e75425so3067537a12.2 for ; Thu, 11 Jun 2026 02:05:52 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1781168751; cv=none; d=google.com; s=arc-20240605; b=Rx0A9L1etIAFkn1mWUXFiUx4X0jQczntkDxsHJgGNgnSU6944z86cl27X0iwkKRA14 oOvqn5PPxWSfF7v9ZpsoG/evyoTNwiqYUKt6mn1BgKpUYPNA8pO6bgQ8bqj1QEx/Kk5W DRVbskuA1WEAub5EA5VgNi5eMefPpxyr5agcygne4nvzXbvwOdSgp5mXRxDhuBazf1TV XA5pniURXWZ1+8MD/VrDYCbUC6IcL23FtmL7XxG9nGZ+BZlWTXntCKAm8J5P8+9NQ24R VAb50vmdNCX1NjYPrdkIfbn3NOQWBnBmgjnJSTjPcBAO8BY91mj4gzoxsAToT6OeYelc 6uRw== 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=r86B2PD+2YR5ipISXAUbgXqW+kHvl60bqTaoDS7LxEE=; fh=pLbP702GoikiXNP0jBBPeJmne/0hI/9Fph/MiZbfrkM=; b=WFBmFQ22tcWpw9efKHgntUm54A84/7JhmJwMpxex49ckFlzxXSOuuW5xgyPsIU8z1g h8nl/s5Sdp35ZcajzOemebqMtykxdzH06FYzrg7m7ytGWAVTYUnvlY67BlhkMQSHG04w jjAZf3Zd+/PtXV2LnL1DTy6EkuXegV2YvNjJyu4gkR2WXZ+N32EAIXQYxhORtSkwhNzX IbMp7zFe8HRxpRn18BNC5qVSNkRZu/XXepA1TGpbBjXOby+V8Bq1q1HGM6LPBjgIZPsS 4X68xdoP0Ve92E+lFFW4tWZB5LX4S9lRmEj4/Fd9ClGoYC5qm9j9KlZBdvpV0uuVakve P8UQ==; 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=1781168751; x=1781773551; 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=r86B2PD+2YR5ipISXAUbgXqW+kHvl60bqTaoDS7LxEE=; b=PnD5DOnl0qW1WddLOzEWwCQUwaYygE4W/uYD7k0gaBoHgLd5393k0thJILunb5UuGX DZTOvUIV71/09Wg/gp2+AU3MCl4O47pUzLWO6dNUKpKsO5dcjzC9rtZVev1xXsilF9J4 +OkuTxUtiX8D32bMLmd0tIcqxJ1a87QXenDqB8oQhBIL1Jn02p3wKeSoVHOUPLN6/s36 UlwROTQ5QNztSZMYwYF4sItFB9eY/ufSEwDg+JC1xsPT6jpG4kU4x0w+DJhX2H+EpBtZ LdJ8wDCQI1Mynh90mR/KuQkoe2OvnrdI/Up9cuCM7JoTpLG6IJBZtZ+APiUMxyzVgMRS 4dQA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1781168751; x=1781773551; 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=r86B2PD+2YR5ipISXAUbgXqW+kHvl60bqTaoDS7LxEE=; b=Zm9vClT6GyRkJvWd0UfrM4PSdGqnceWQq5enm+X/ghaWhV1qIhcF4LQuAMSenR9WYS o2JJmYnW382rVFv+VRSWe2sIC0cVak3sDLBbFQgYsGRvWzN9BCzjGmt++b75Mh6jwWyd zmPjk7ftgxg+qSGc0MT5U+TkTb/7Yvehq2UGICbPPpmot/+LZFVPRnpbBONdMagp7CCR 2Ah5LZ1sinpGDb1Gjwzvkmwc2gHwozvBtMZXcJE8Hnzv9A0lWzt60ZvLlGmm/STxMaZV FMnqqMsZTwvhkWBkp2f7zel/RJUTcjlPvrDU+1/Ip85nccweo/xpRLClmxGifdwCndyz ElWw== X-Forwarded-Encrypted: i=1; AFNElJ/Pv6yrUodk8iFG33Itov0DtZtSEVBT7Sf2lzHH1F15X96a2GTwsAR3mHmOcmlY90VeMgQzX+Ro7FiaYzAO@postgresql.org X-Gm-Message-State: AOJu0YymXyr2KrQCxWlPChY5rwwWLBmzhpXDuWnfqxOiogjcKU717hbr XWTjnM3y5i8kNJEyWBSP7vYAmbOoGrUGKA6JaDduPQdLbaq4gdtEtgc5iW9ehxeumrNh+AWFM8y BQwWFhb0mIougnd1t3SMqVcg1dHzo+Gs= X-Gm-Gg: Acq92OFohbodTKTyrGKvt4IjIO6Ej3URGWwgGZDlHZ2yCoyZJdeZ4Cx0s3AvrMKDkpd 7tl4A8qVkgFvyJ+aTVSvnT0mlO7Uy6K0JhUl7e3HPJL3/jJVZ6KZpr6UZPBisTTwYpo8U/Lrfky cCd87p+t8om+SdocnxFxJED/F3hyYQG9yq+SOPkuboeLsEnJA5SJ8+kIDS32n8B5eMu38L661VU ShJAaIwWVEHbWTFyVaHQ++0Dv+eEs+zi9czSy8XZru+qXJ/XEHaxSg+1FnedcFG/TeDpu2rCsz5 bxuoMKSMh+Z7+t252kS67twz3ThG77d2Vj2hVc9ZlhftbxAclQc7pvd85q3ZbbwyEHAYFOtzohI = X-Received: by 2002:a05:6a21:4688:b0:39c:1f:3211 with SMTP id adf61e73a8af0-3b5e32270a2mr2150485637.20.1781168751409; Thu, 11 Jun 2026 02:05:51 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Amit Langote Date: Thu, 11 Jun 2026 18:05:34 +0900 X-Gm-Features: AVVi8CfpEc3Qj39jRTF3xUDQdDA8KbEdbMC9lOWGvVIzWJARDuv5yM3HJ4sEZc8 Message-ID: Subject: Re: PG19 FK fast path: OOB write and missed FK checks during batched To: Junwang Zhao Cc: Ayush Tiwari , Nikolay Samokhvalov , pgsql-hackers mailing list , Andrey Borodin , Kirk Wolak 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 Thu, Jun 11, 2026 at 5:18=E2=80=AFPM Junwang Zhao wr= ote: > I only reviewed and applied patch 0001 on my local machine, and it > successfully fixed the crash. > > One minor comment: > > + if (fpentry->flushing) > + { > + ri_FastPathCheck(riinfo, fk_rel, newslot); > + return; > + } > > Would it be worth wrapping the condition with unlikely()? It seems > this branch is expected to be false in most cases, not a strong > opinion though. Good idea. Will do. Are you planning to look at 0002? --=20 Thanks, Amit Langote