Re: Built-in connection pooler

On Thu, Jan 24, 2019 at 08:14:41PM +0300, Konstantin Knizhnik wrote:
> The main differences with pgbouncer&K are that:
>
> 1. It is embedded and requires no extra steps for installation and
> configurations.
> 2. It is not single threaded (no bottleneck)
> 3. It supports all clients (if client needs session semantic, then it will be
> implicitly given dedicated backend)
>
>
> Some performance results (pgbench -S -n):
>
> ┌────────────────┬────────┬─────────────┬─────────┬─────────────────────────┐
> │ #Connections │ Proxy │ Proxy/SSL │ Direct │ Direct/SSL │
> ├────────────────┼────────┼─────────────┼─────────┼──────────────┤
> │ 1 │ 13752 │ 12396 │ 17443 │ 15762 │
> ├────────────────┼────────┼─────────────┼─────────┼──────────────┤
> │ 10 │ 53415 │ 59615 │ 68334 │ 85885 │
> ├────────────────┼────────┼─────────────┼─────────┼──────────────┤
> │ 1000 │ 60152 │ 20445 │ 60003 │ 24047 │
> └────────────────┴────────┴─────────────┴─────────┴──────────────┘

It is nice it is a smaller patch. Please remind me of the performance
advantages of this patch.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +