How to avoid intstantiating multiple JVM instances across different sessions to use FDW? - Mailing list pgsql-general

From ganggewang(王刚)
Subject How to avoid intstantiating multiple JVM instances across different sessions to use FDW?
Date
Msg-id 662D5859-41D5-4AAA-A965-F936AB5D193F@tencent.com
Whole thread Raw
List pgsql-general

Hi there,

 

I am recently implementing a new FDW, which would internally instantiate a JVM instance to invoke JNI calls, and the JVM instance would be created in a session when a new query that hit the foreign table comes.

I notice for each session, PG would fork a new process. While the JVM instance is available only in the same process. Do you have any suggestion to reuse the same JVM instance across different sessions to reduce memory usage?

 

Thanks in advance.

pgsql-general by date:

Previous
From: shashidhar Reddy
Date:
Subject: Unable to use pg_verify_checksums
Next
From: Guillaume Lelarge
Date:
Subject: Re: Unable to use pg_verify_checksums