Re: Built-in connection pooling - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Built-in connection pooling
Date
Msg-id ee7a5662-48d6-3de7-8bf0-48757da836e0@iki.fi
Whole thread Raw
In response to Re: Built-in connection pooling  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
Responses Re: Built-in connection pooling  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
Re: Built-in connection pooling  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: ON CONFLICT DO UPDATE for partitioned tables
Next
From: Konstantin Knizhnik
Date:
Subject: Re: Built-in connection pooling