Re: Built-in connection pooling

On 06.04.2018 20:00, Konstantin Knizhnik wrote:

Attached please find new version of the patch with  several bug fixes + support of more than one session pools associated with different ports.
Now it is possible to make postmaster listen several ports for accepting pooled connections, while leaving main Postgres port for dedicated backends.
Each session pool is intended to be used for particular database/user combination.

Sorry, wrong patch was attached.

Development in built-in connection pooling will be continued in  https://github.com/postgrespro/postgresql.builtin_pool.git
I am not going to send new patches to hackers mailing list any more.
The last added feature is support of idle_in_transaction_session_timeout which is especially critical for builtin pool with transaction-level scheduling because long transaction can block other sessions executed at this backend.

-- 
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company