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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1tHmUN-009nEs-5C
	for pgsql-hackers@arkaria.postgresql.org; Sun, 01 Dec 2024 16:08:03 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1tHmTM-008U4U-DM
	for pgsql-hackers@arkaria.postgresql.org; Sun, 01 Dec 2024 16:07:01 +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 <sk@zsrv.org>)
	id 1tHmTM-008U4M-17
	for pgsql-hackers@lists.postgresql.org; Sun, 01 Dec 2024 16:07:01 +0000
Received: from forward103b.mail.yandex.net ([2a02:6b8:c02:900:1:45:d181:d103])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <sk@zsrv.org>)
	id 1tHmTE-000VMA-Qm
	for pgsql-hackers@lists.postgresql.org; Sun, 01 Dec 2024 16:07:00 +0000
Received: from mail-nwsmtp-mxback-production-main-82.sas.yp-c.yandex.net (mail-nwsmtp-mxback-production-main-82.sas.yp-c.yandex.net [IPv6:2a02:6b8:c10:3392:0:640:edcb:0])
	by forward103b.mail.yandex.net (Yandex) with ESMTPS id A97C460AFC;
	Sun,  1 Dec 2024 19:06:49 +0300 (MSK)
Received: from mail.yandex.ru (2a02:6b8:c23:59e:0:640:a1a:0 [2a02:6b8:c23:59e:0:640:a1a:0])
	by mail-nwsmtp-mxback-production-main-82.sas.yp-c.yandex.net (mxback/Yandex) with HTTPS id Z6gHaC6OwCg0-CzumQ3pg;
	Sun, 01 Dec 2024 19:06:48 +0300
X-Yandex-Fwd: 1
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zsrv.org; s=mail;
	t=1733069208; bh=UekTpl87VZ58lW5448QdXRloOVc8QaH6rSJsn9JVJlQ=;
	h=Message-Id:Date:Subject:To:From;
	b=kHXCFZTyAcD1uHq1f2M/Pu23SujcbkaWYnZPSTWS5nn+HhENR64Gl3H+db8RmThpq
	 dY/fGzovdrqGRjfwfmdoY1VTH0gSIT2GTpQ8r2UGf5IoPGXoS889D31sCZhz6AtHYs
	 FRDJ57fPl1scRxgulXGMkuf3+UlaFojNxBvbmeis=
Authentication-Results: mail-nwsmtp-mxback-production-main-82.sas.yp-c.yandex.net; dkim=pass header.i=@zsrv.org
Received: by mail-sendbernar-production-main-71.sas.yp-c.yandex.net with HTTP;
	Sun, 01 Dec 2024 19:06:48 +0300
From: Sergei Kornilov <sk@zsrv.org>
To: jian he <jian.universality@gmail.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: speedup ALTER TABLE ADD CHECK CONSTRAINT.
MIME-Version: 1.0
X-Mailer: Yamail [ http://yandex.ru ] 5.0
Date: Sun, 01 Dec 2024 19:06:48 +0300
Message-Id: <47131733068852@mail.yandex.ru>
Content-Transfer-Encoding: 7bit
Content-Type: text/plain
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/47131733068852%40mail.yandex.ru>
Precedence: bulk

Hello!
Thanks for the patch, but I think using SPI is still not allowed here: https://www.postgresql.org/message-id/9878.1511970441%40sss.pgh.pa.us

> if it uses SPI for sub-operations of ALTER TABLE I think that is sufficient reason to reject it out of hand.

regards, Sergei