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 1wAnyn-000MWL-0f for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Apr 2026 11:55:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wAnyl-005eV4-0Q for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Apr 2026 11:55:24 +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 1wAnyk-005eUv-2i for pgsql-hackers@lists.postgresql.org; Thu, 09 Apr 2026 11:55:23 +0000 Received: from mail-pj1-x1033.google.com ([2607:f8b0:4864:20::1033]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wAnyi-00000000Axd-2FCl for pgsql-hackers@postgresql.org; Thu, 09 Apr 2026 11:55:23 +0000 Received: by mail-pj1-x1033.google.com with SMTP id 98e67ed59e1d1-35c206f0481so805489a91.0 for ; Thu, 09 Apr 2026 04:55:20 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775735718; cv=none; d=google.com; s=arc-20240605; b=Ew9W3EkQiDMcwryYOSSmPwvwkItx8N7b7WXBCi5Zr+Ksqdcf+xw/toTwOltd1VJcUm 7QYnazAeYpc+16KNumUjjA4t/WyWaWT+RiWsXVVAawcGEHuRvv6kzhx08eVkYCk18VKN VNuC70uRX5+RQEehO5T+X+/y+vZahArr+M+09NyU8iJhbP/pv7diVObuV1cA5TdL4J6y A8yi3NfsJbHIUtU5RFQhw7k22TQKDMSgzu3JqgkDZNuLJdRDYiSZPmm2grl2nu8L1Kip Bd8sjF5MgKNkEssgV/AuYzrG49O+J8zh6XEMW1y7xUx/tlXL+e1XFUWNyDo+k+ed54+y qliQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=Prjl5n/uAI93SmzPe8HKdzoX6AuOqq7OzN77g7z97pc=; fh=xujuYwstKqOi0vgvm64gtVhJakiIdMU5A+M/pIfe3qs=; b=LMZ4tlJQHrzKOVRY8Fm8Yj+eG78OSP8zNxUIMmMVbkogYnzgQXri+y7HOCcEJ12wS0 kxqI9qbZM5XS9eOioJYxR2Vwc5ZcyOXE0DrsuO+VZcrbORVUVoRm7w1/osekR1VYK6h7 KSjxUXV5ZbWQjEDWEvU/qnO2vNjRieZd7ML7M1iUrFUVWHuKs+QR8VX2Vdq75FTlIqd+ Psju7rBLAWfkrJWhzYeww9TWNHbRkCxGGMb2ToILZ8WaNmDJnDtaCaJVtgkWRf14qxym Dmfp9CmDxHKyRCQzgANv/C0w2nR2LfdS5KLgm5eARyJkjvJN8dMS7kV2PbKVflXOVYSb YNkw==; 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=1775735718; x=1776340518; darn=postgresql.org; h=content-transfer-encoding:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=Prjl5n/uAI93SmzPe8HKdzoX6AuOqq7OzN77g7z97pc=; b=iKX7qBBR0Wvi8+LKrbccHQ+mfaguWir7ObFafRnIZNvamKmU8krMcqDfRTvHYC9D5h pL68ojk3uzgRTaaHKnsoYgXTNeWiYvb/roeyn0oR3iiHtrIC08Ju6qfUtlxzeozXAS9N 7JKJSBnBVAhWDvfTUmpHpRVpX5vQPYAhCPl5UN0zWonvw9QbnONbjRxWVwH2RS0G+eQj HoGdqv2mHvEFs46pm+qwWwBUPgzBx0uW0p4XBV4mm2ey0KphZhmjh63ZodUECp0te4Ib i4Mfnnh6jM5WzxrGg32f885Dp4E2PXyOeC0M0cB/8ZOcSWAH4t8b0HxiMKeWlngcj2G5 JsSg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775735718; x=1776340518; h=content-transfer-encoding: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=Prjl5n/uAI93SmzPe8HKdzoX6AuOqq7OzN77g7z97pc=; b=S4bN8aLrXoR1B+bqJOxrYhDMXgMozhiTQvWU5YbSrezw1CHhKsEysoO2PiYkpxAxd6 hO4Fb7aZJhJpnwDavCgST2Kbo2HcxH8ex04MxxbKW44aBzMFjejNsLpHChf46RYq2E7F sFXjGXj6lkrnKtswq/MVm0orsE4aoKjPHmjytcF3T6d48cztqiIJNnfX3z8LbRAUFZ8k P65X+GIT+txhWQStu3gjAbr8a8Wq98fxzLuEslCBOLTYBQNb9Q7bOpML8HUb+pb2iu/i 18xiqGiw3kxRkVqAmje6TfaluDcM/phxK/AthnQsCQ/qV3ytML/3rkr1e58h6zyW0DNQ wJQg== X-Forwarded-Encrypted: i=1; AJvYcCUnbWYEv6zqrr3ezzWrqKJFFs9XDf6HTxGs13Cy1NkFqjIZJnCxUCIZDOVROotuTHGOTVYmawj0gQE/guKI@postgresql.org X-Gm-Message-State: AOJu0YzLbkTobhDzBKi3l4WkkaUT3O+lSygwRhSCBleI+z09WA2xCCHx +jaeSlAq6bMHzRaSOLQl4Zq3/pUSB0aJBEfnedpU3+QpzmOe4h9Pbbr/Ch08k5NkjBxsEls/60K cOo7UUbguXvqZquOZ0nszokcPeRUfQkA= X-Gm-Gg: AeBDiesWuHlCIJ4M328KjELLIVAQa0mVXATkpZgjX/oLH5qvKh5V5+5Av6Iyeiq6E3z V7dAFaNg08fyf+pyAo+OokVkrAE4rBAlhnpjNk8/RUyroKdb+K3x9/JwPQjGRAhvMeVSZgmTkIV /Sy8OdMvglhbVY46Zt4GiLjdxqw6qrKjrKsCDHU2P8eOa/s+u2SZmvA/lZXjuGKz3pK0QbAtriM VurV1FRl5I9qM20ZoLpn8kyC67aFJpS82rjDNrCYv+573K+HZhRGq36AcXxzRhyZI+94q0sd+sT PCWXx5cAeOWTnwl7HVQwdbg4BYEmZGv8PCa95vCV31o3DOyfT4r+HBgba2IIaC+/ X-Received: by 2002:a17:90b:5111:b0:35d:93ff:2855 with SMTP id 98e67ed59e1d1-35de67eba6amr24980538a91.8.1775735718546; Thu, 09 Apr 2026 04:55:18 -0700 (PDT) MIME-Version: 1.0 References: <43b56e3b-80d6-4a45-a313-cb1caa587b22@vondra.me> <1290fac7-8430-4d2c-bfcb-00c65adff5e5@vondra.me> In-Reply-To: From: Amit Langote Date: Thu, 9 Apr 2026 20:55:01 +0900 X-Gm-Features: AQROBzDu5XxmBkpp_q3kncdVlQYUDmyecivezns8dcSbimnY2BMAfov-1R1FBFc Message-ID: Subject: Re: Eliminating SPI / SQL from some RI triggers - take 3 To: Sandro Santilli , Tomas Vondra , Amit Langote , Junwang Zhao , Pavel Stehule , PostgreSQL-development 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 Hi Sandro, On Thu, Apr 9, 2026 at 8:07=E2=80=AFPM Sandro Santilli wrote: > On Mon, Mar 02, 2026 at 01:34:41PM +0100, Tomas Vondra wrote: > > > > TBH I haven't noticed the memory context issue myself, I only noticed > > because the builds with index prefetch started crashing. > > We're getting a crash in PostGIS too, since that commit was merged into > the master branch, see https://trac.osgeo.org/postgis/ticket/6066 > > The crash is triggered a C function using SPI. Evan Montgomery-Recht posted a report of the same issue on this thread a couple of days ago. I have posted a patch to fix the issue, which I will commit tomorrow after a bit more testing. --=20 Thanks, Amit Langote