Re: Built-in connection pooling

On 18/04/18 07:52, Konstantin Knizhnik wrote:
> 
> 
> On 18.04.2018 13:36, Heikki Linnakangas wrote:
>> On 18/04/18 06:10, Konstantin Knizhnik wrote:
>>> But there are still use cases which can not be covered y external
>>> connection pooler.
>>
>> Can you name some? I understand that the existing external connection
>> poolers all have their limitations. But are there some fundamental
>> issues that can *only* be addressed by a built-in implementation?
> 
> Well, may be I missed something, but i do not know how to efficiently
> support
> 1. Temporary tables
> 2. Prepared statements
> 3. Sessoin GUCs
> with any external connection pooler (with pooling level other than session).

Me neither. What makes it easier to do these things in an internal 
connection pooler? What could the backend do differently, to make these 
easier to implement in an external pooler?

- Heikki