Re: speedup ALTER TABLE ADD CHECK CONSTRAINT.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sergei Kornilov <sk(at)zsrv(dot)org>
Cc: jian he <jian(dot)universality(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: speedup ALTER TABLE ADD CHECK CONSTRAINT.
Date: 2024-12-01 17:22:09
Message-ID: 1355327.1733073729@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Sergei Kornilov <sk(at)zsrv(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michel Pelletier 2024-12-01 17:38:04 Re: Code cleanup for detoast a expanded datum.
Previous Message Tom Lane 2024-12-01 16:57:23 Re: CREATE SCHEMA ... CREATE DOMAIN support