2016-07-15 18:43 GMT+02:00 james <ja...@mansionfamily.plus.com>:

> On 15/07/2016 09:28, Craig Ringer wrote:
>> I don't think anyone's considering moving from multi-processing to
>> multi-threading in PostgreSQL. I really, really like the protection that
>> the shared-nothing-by-default process model gives us, among other things.
>> As I understand it, the main issue is that it is hard to integrate
> extensions that use heavyweight runtimes and are focussed on isolation
> within a virtual machine.  Its not just
> Perhaps it would be possible for the postmaster (or a delegate process) to
> host such a runtime, and find a way for a user process that wants to use
> such a runtime to communicate with it, whether by copying function
> parameters over RPC or by sharing some of its address space explicitly to
> the runtime to operate on directly.
> Such a host delegate process could be explicitly built with multithread
> support and not 'infect' the rest of the code with its requirements.
> Using granular RPC is nice for isolation but I am concerned that the
> latencies might be high.

What I know about Oracle, PL/SQL, Java - all is executed as outprocess
calls. I am sure, so PL doesn't share process with SQL engine there



> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to