Search Postgresql Archives

Re: Keeping state in a foreign data wrapper

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thank you again, I have another question in order to make sure I have a clear understanding:


> On 4 Aug 2020, at 11:24, Ian Lawrence Barwick <barwick@xxxxxxxxx> wrote:
> 
> The hash table is specific to each running backend so will only be
> accessed by that process.
> 
> Pre-loading a shared library just gives the library an opportunity to
> set up shared memory etc. You can always try adding one of the FDW
> libraries to "shared_preload_libraries" and see what happens
> (theoretically nothing).
> 

My impression was that since each client (e.g. libpq) connection results in the creation of a Postgres process in the backend (https://www.postgresql.org/developer/backend/) then this  (mysql) "connection pool" hash table is not global per se and shared among the different client / users sessions. But that defeats the purpose, no? 

Thank you
Best 
Stelios








[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux