Re: Data Packaging/Data Unpacking - Mailing list pgsql-general

From oleg yusim
Subject Re: Data Packaging/Data Unpacking
Date
Msg-id CAKd4e_Enu1SR=3FAFM1-m91uBX+K7FuDyzDhHM7wY5MG+D8=tA@mail.gmail.com
Whole thread Raw
In response to Re: Data Packaging/Data Unpacking  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Data Packaging/Data Unpacking
List pgsql-general
OK, Kevin, David,

Thanks you very much for explanation. Now who is the owner of this process? My understanding is, data then located physically in RAM, in the memory stack assigned by OS to this process. Now the question is who owns the process?

Thanks,

Oleg

On Wed, Jan 13, 2016 at 3:29 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wed, Jan 13, 2016 at 2:19 PM, Kevin Grittner <kgrittn@gmail.com> wrote:
On Wed, Jan 13, 2016 at 2:57 PM, oleg yusim <olegyusim@gmail.com> wrote:

> Say, I got network package. The package was decrypted by OpenSSL. Where this
> data are, physically, at this moment?

Process-local memory for the PostgreSQL backend process associated
with the database connection.

> Opposite situation: we are about to send results of SELECT statement over
> the OpenSSL tunnel. Where are the data, physically, between the moment DB
> engine returned results for my query and moment the package was encrypted by
> OpenSSL?

Process-local memory for the PostgreSQL backend process associated
with the database connection.

​In other words (?) while OpenSSL may be a separate project the method of its use involves loading all relevant code into the process space​
 
​of PostgreSQL - specifically the process that was forked when the SSL client connection was established.

David J.​

pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: plpython3 package absent in 9.5 repository
Next
From: "Joshua D. Drake"
Date:
Subject: Re: WIP: CoC V5