Re: C trigger significantly slower than PL/pgSQL? - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: C trigger significantly slower than PL/pgSQL?
Date
Msg-id 2000624.1681579915@sss.pgh.pa.us
Whole thread Raw
In response to Re: C trigger significantly slower than PL/pgSQL?  (Ernst-Georg Schmid <pgchem@tuschehund.de>)
List 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 by date:

Previous
From: Ernst-Georg Schmid
Date:
Subject: Re: C trigger significantly slower than PL/pgSQL?
Next
From: Timothy Nelson
Date:
Subject: Like AppSmith, but dedicated to Postgres?