Re: One process per session lack of sharing

From: AMatveev(at)bitec(dot)ru
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: james(at)mansionfamily(dot)plus(dot)com, Craig Ringer <craig(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <Pgsql-hackers(at)postgresql(dot)org>
Subject: Re: One process per session lack of sharing
Date: 2016-07-18 09:17:54
Message-ID: 06873259.20160718121754@bitec.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

> 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.
I agree with you.
Moreover I think that some decision have not sense with this "thread model" in any way.
For example Embedded oracle XML DB applications:
http://docs.oracle.com/cd/B28359_01/appdev.111/b28369/xdb23jv1.htm#i1043708
"""
You can run a Java servlet.
Servlets work better as the top-level entry point into Oracle Database, and require using HTTP(S) as the protocol to access Oracle Database.
"""

> 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

It's better to say that java is executed like outprocess calls.
It's done for wide libraries support.
But it is not separate process.
"""
The JDBC server-side internal driver,
the Oracle JVM, the database, and the SQL engine all run within the same address space, and therefore, the issue of network round-trips is irrelevant
"""
http://docs.oracle.com/cd/E11882_01/java.112/e16548/overvw.htm#JJDBC28026

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message AMatveev 2016-07-18 09:25:10 Re: One process per session lack of sharing
Previous Message Antonin Houska 2016-07-18 09:00:27 Typos in logical decoding