Re: Pl/Python runtime overhead

Thanks for the confirmation Peter,
I guess I'll take a good look at the existing implementations.

All the best
Seref

On Fri, Aug 9, 2013 at 10:24 PM, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:

> On 8/7/13 10:43 AM, Seref Arikan wrote:
> > When a pl/python based function is invoked, does it keep a python
> > runtime running across calls to same function? That is, if I use
> > connection pooling, can I save on the python runtime initialization and
> > loading costs?
>
> The Python interpreter is initialized once during a session, normally
> when the first PL/Python function is called. So yes, connection pooling
> can be helpful here.
>
> > Are there any documents/books etc you'd recommend to get a good
> > understanding of extending postgres with languages like python? I'd
> > really like to get a good grip of the architecture of this type of
> > extension, and possibly attempt to introduce a language of my own
> > choosing. The docs I've seen so far are mostly too specific, making it a
> > bit for hard for me to see the forest from the trees.
>
> The basic documentation is here:
> http://www.postgresql.org/docs/devel/static/plhandler.html. The rest is
> mainly experience and copying from existing language handler
> implementations.
>
>