Re: C trigger significantly slower than PL/pgSQL?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: C trigger significantly slower than PL/pgSQL?
Дата
Msg-id 2000624.1681579915@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: C trigger significantly slower than PL/pgSQL?  (Ernst-Georg Schmid <pgchem@tuschehund.de>)
Список pgsql-interfaces
Ernst-Georg Schmid <pgchem@tuschehund.de> writes:
> I have still a follow-up question, though. Since I'm not calling 
> SPI_freeplan(), the cached plan lives forever, right?

Till the per-session server process exits.  I wouldn't call it
a leak as long as you can reuse the plan in later calls in that
session; a static variable's scope is fine for that.

            regards, tom lane



В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Ernst-Georg Schmid
Дата:
Сообщение: Re: C trigger significantly slower than PL/pgSQL?
Следующее
От: Timothy Nelson
Дата:
Сообщение: Like AppSmith, but dedicated to Postgres?