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.94.2) (envelope-from ) id 1u0HgF-00Fncs-5Q for pgsql-hackers@arkaria.postgresql.org; Thu, 03 Apr 2025 10:20:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u0HgD-005Ylx-Rl for pgsql-hackers@arkaria.postgresql.org; Thu, 03 Apr 2025 10:20:13 +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.94.2) (envelope-from ) id 1u0HgD-005YlC-HP for pgsql-hackers@lists.postgresql.org; Thu, 03 Apr 2025 10:20:13 +0000 Received: from mail-pg1-x52b.google.com ([2607:f8b0:4864:20::52b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u0HgB-0038a4-0X for pgsql-hackers@postgresql.org; Thu, 03 Apr 2025 10:20:12 +0000 Received: by mail-pg1-x52b.google.com with SMTP id 41be03b00d2f7-af51596da56so655434a12.0 for ; Thu, 03 Apr 2025 03:20:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1743675609; x=1744280409; 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=iymbIv2TdhXonnDn1QYzmI4uXc6Su3M/rqauvt5Sttg=; b=a96BwnSS8w5HonQqDssS7XzMQzj6TaB8OIF1w5LzppH+rCE1szft/rcQcqtFX9LUZV imLb4HJVHr12MTjQgRmwUrXC/hhLSxf3SXfC0rzi/a222kHKCjbdr9wNc1mb7O3iYeYc MIQD1A2ZXGSh9HH7lhVnsyGCJri3O9Us3Zq6OpCmwWScVSFaKI+EJOgKPYIBQkg1Vith JuYg2M1NXNi/G2rylLdGaT6woUMXGkBUk420Zkp881bZ6VakMcC/bVnYwCKhbbpdVOMC Cfswi/ZnHUtwIGKK1XYOcIMtAiacYlBSHP2dAlFJeBVF4MuMbaiPRUzmtL7781MeGMfC vQyg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743675609; x=1744280409; h=content-transfer-encoding:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=iymbIv2TdhXonnDn1QYzmI4uXc6Su3M/rqauvt5Sttg=; b=dbkdcICnlG/eJX6ZkuWCmMk9i9PSEbvus9SR0/SFKfut1UsSGWBi11zQCtOVYoM0Jf RzAm3kG9uuVqC70iQdD0etDhW4Y8yWV5c6dGTu2F9m0fFrb7NF+u2olW0ytteNfE5TnE A4ULc4WKlKEiGaRVpCoNJHGyhHhGRj9bWSCmLnLUhxmevU0EATnuhTSPM+r49cwgcn3p Ht6wROeCGnWJSkYDHZQNiVFhRDSDDGntNM2eebj/4KrIVN4KYasCPHKpcJ+FAPAFju1z e/NVv/9Xge8TShxIm1wG8PjiqFcu8Y40LRm0KC0yiVKGWmWKXjO52SR5PiOc78xfOasa eL6Q== X-Gm-Message-State: AOJu0YzLWBgcRvVqq5RnFCK8COZZ8Sqnbwx7hPfBBMAVrANv8OTUSv9C e6UH+f1Y8bfRj0Krf6CPpNQc3/7rEBBulAUYE0ZyZP8+uFIH3+95MlCaNCKKG1/Jh7+9AOcwblX +XnNqtGXhIQsn68IMeVeeH6dTDoafTm9W X-Gm-Gg: ASbGncufCoryePT8ShHYIa+dwrqRGmGIvhyP7CSIAQazAi45M/DeQm5dApDD3egIRPd q1yZ7qMt7vM4orYM4y3JVNYtECcNY3pO6cKhYHUroWJhwKmbaRtpzrGbyClFq9vGFLr6EtJYAl9 M0zb/t20sPidRjZcCqm1a65wXGWs8= X-Google-Smtp-Source: AGHT+IFQGiWVelwnhruqcfkoyAutId2CRKsCWQAOf9gjAqGSmjP3Zw6lvc/L5WXLEj7IlUlon4U8FziRxQrT/94IKbU= X-Received: by 2002:a17:90b:5685:b0:2ff:618c:a1e0 with SMTP id 98e67ed59e1d1-3053215a257mr28630555a91.29.1743675609152; Thu, 03 Apr 2025 03:20:09 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Amit Langote Date: Thu, 3 Apr 2025 19:19:53 +0900 X-Gm-Features: AQ5f1JqcZKuSLIXbyBifIJ1z52m6eFo3oFgPDZlBxwQHsd0pO0Ak7cyZxTrhadw Message-ID: Subject: Re: Eliminating SPI / SQL from some RI triggers - take 3 To: 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 On Fri, Dec 20, 2024 at 1:23=E2=80=AFPM Amit Langote wrote: > We discussed $subject at [1] and [2] and I'd like to continue that > work with the hope to commit some part of it for v18. I did not get a chance to do any further work on this in this cycle, but plan to start working on it after beta release, so moving this to the next CF. I will post a rebased patch after the freeze to keep the bots green for now. --=20 Thanks, Amit Langote