Date: Mon, 28 Jan 2019 16:10:40 -0500
From: Bruce Momjian <bruce@momjian.us>
To: Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>,
	Dimitri Fontaine <dim@tapoueh.org>
Subject: Re: Built-in connection pooler
Message-ID: <20190128211040.GF26761@momjian.us>
References: <ac873432-31cf-d5e4-0b80-b5ac95cfe385@postgrespro.ru>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <ac873432-31cf-d5e4-0b80-b5ac95cfe385@postgrespro.ru>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk

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@momjian.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 +