Re: Transient plans versus the SPI API

Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> A control knob sounds limited. For instance, what if the application
> knows that some parameters will be constant over the time that the plan
> is saved? It would be nice to be able to bind some parameters to come up
> with a generic (but less generic) plan, and then execute it many times.
> Right now that can only be done by inlining such constants in the SQL,
> which is what we want to avoid.

+1

I was already thinking in those term at the application level for the
example I've been using before in this thread, and only reading your
mail I realize that maybe the backend should be able to do that itself.

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support