Re: Does a call to a language handler provide a context/session, and somewhere to keep session data?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Does a call to a language handler provide a context/session, and somewhere to keep session data?
Date: 2016-03-07 23:40:27
Message-ID: 56DE116B.8050100@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/7/2016 3:28 PM, david(at)andl(dot)org wrote:
> [dmb>] Thanks. Yes, I knew that. My problem is a strategy to start up the language engine once (per session), load stuff from the database once, and then keep the per-call cost as low as possible....

this stuff you're loading from the database once, that's just data about
your language plugin's configuration, or is it user data, or what?

if its just a few global settings, you should consider using custom
settings variables, rather than database tables. for instance, pljava
has a setting,
pljava.libjvm_location='/usr/lib/jvm/java-1.8.0/lib/libjvm.so' or
whatever which it uses to find the Java native calls interface library...

--
john r pierce, recycling bits in santa cruz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thiemo Kellner, NHC Barhufpflege 2016-03-07 23:49:32 Logger into table and/or to cli
Previous Message david 2016-03-07 23:28:00 Re: Does a call to a language handler provide a context/session, and somewhere to keep session data?