Re: PL/Python SD dict wiped? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: PL/Python SD dict wiped?
Date
Msg-id 7f2dfe82-a8cc-8e5b-e9cf-5c625b39b41b@2ndquadrant.com
Whole thread Raw
In response to RE: PL/Python SD dict wiped?  (Ken Huffman <KHuffman@westell.com>)
Responses Re: PL/Python SD dict wiped?
List pgsql-hackers
On 1/8/18 11:59, Ken Huffman wrote:
> I'm fine with per-session initializing of prepared statements, but is
> there PL/Python mechanism that spans sessions to minimize ConfigParser
> calls?

Nothing built-in.  You would have to use a separate external storage
mechanism of some kind.  It could be a file, separately managed shared
memory, or perhaps something like memcached.

However, if this is the problem, then you might want to figure out a way
to keep your connections open longer, such as by using a connection pool.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Parallel append plan instability/randomness
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] VACUUM and ANALYZE disagreeing on what reltuples means