Re: speedup ALTER TABLE ADD CHECK CONSTRAINT. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: speedup ALTER TABLE ADD CHECK CONSTRAINT.
Date
Msg-id 1355327.1733073729@sss.pgh.pa.us
Whole thread Raw
In response to Re: speedup ALTER TABLE ADD CHECK CONSTRAINT.  (Sergei Kornilov <sk@zsrv.org>)
List 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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: CREATE SCHEMA ... CREATE DOMAIN support
Next
From: Michel Pelletier
Date:
Subject: Re: Code cleanup for detoast a expanded datum.