Horton

Re: speedup ALTER TABLE ADD CHECK CONSTRAINT.

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sergei Kornilov <sk@zsrv.org>
Cc: jian he <jian.universality@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2024-12-01T17:22:09Z
Lists: pgsql-hackers 
Sergei Kornilov <sk@zsrv.org> writes:
> 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

Yeah, if you want to do this you need to code the catalog lookup in
C.  SPI just adds too many variables to what will happen, on top
of being enormously expensive compared to a handwritten lookup.

			regards, tom lane