Re: speedup ALTER TABLE ADD CHECK CONSTRAINT.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: speedup ALTER TABLE ADD CHECK CONSTRAINT.
Дата
Msg-id 1355327.1733073729@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: speedup ALTER TABLE ADD CHECK CONSTRAINT.  (Sergei Kornilov <sk@zsrv.org>)
Список 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 по дате отправления: