Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1l1TH7-0007ps-Rq
	for psycopg@arkaria.postgresql.org; Mon, 18 Jan 2021 12:04:49 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1l1TH6-0006ti-M0
	for psycopg@arkaria.postgresql.org; Mon, 18 Jan 2021 12:04:48 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <daniele.varrazzo@gmail.com>)
	id 1l1TH6-0006tb-Er
	for psycopg@lists.postgresql.org; Mon, 18 Jan 2021 12:04:48 +0000
Received: from mail-lj1-x22c.google.com ([2a00:1450:4864:20::22c])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <daniele.varrazzo@gmail.com>)
	id 1l1TH1-0001Zr-9G
	for psycopg@postgresql.org; Mon, 18 Jan 2021 12:04:47 +0000
Received: by mail-lj1-x22c.google.com with SMTP id m13so17903165ljo.11
        for <psycopg@postgresql.org>; Mon, 18 Jan 2021 04:04:42 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20161025;
        h=mime-version:from:date:message-id:subject:to;
        bh=PRDXnBcZ1ya/TuayUT/IzvW6XiVuEIqNaORi2ASryTY=;
        b=O1hlYKE7wIM9IEyoWYI8dXwz0M0+xyEsSEs/G3thZqxDCA56AUk9tsk+N/c9Zroq8a
         lGI4VAxYC1xtE85ZPiKcdDmfUR7cqxXJtuUuoM76nR88k2WGSi+nTspUuJ8hcPQGeIAp
         3KqzYtqM+SfSbAkWTE5eqZY9wdi6ZYLBW9tqDVYpyLF1LY6u6toPwZVKpd7ByenHly2Y
         vunz3wujNsB9dp0/ZlgbZR/1YbCncD9N7YgGBHKQQJtm78ahgDxoABmu+njO1VwA4Ki1
         /aiytT989PIVNjX5+vAazLOQ3dmmnw+TMoWRqLbMf6qvbFZeGne2JEkS5yVauCv8qh4m
         biFA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:mime-version:from:date:message-id:subject:to;
        bh=PRDXnBcZ1ya/TuayUT/IzvW6XiVuEIqNaORi2ASryTY=;
        b=p2SkqDfR8wqieksMwX7YZTKfd4GxM96aZl9oQRzcfExAndd7CGSZyTXYW2aVn1hJAw
         HW4xopAWOh0qzEvkIuShl1Ha80cFrdAj+ROZSUEqD2dt7U8XE38m7wr1JciRrrzCFbqH
         AZ8XL/ezgXPQ8Ujuej2axeg67ZVShIVqbK4JnJXGzhm8v/BFn/hfT9Go1cB/aaJ2KFGH
         TmTNpArQgVgAqrVIH/xtZcaeA+2eqToyJeQDE7sJ9eFAzQlOdY5+uyxuaLDMxqUl5xHc
         iXa9t0MltJwyfZ6mTwOcoPPPeFkle3+Qp6RfS9uIo3xrBuoy9pt0Ms9xZy5TNcPTSyjy
         xYnQ==
X-Gm-Message-State: AOAM530ry8Fv6lD+R1ZDMJTQSwd3ePBZbc7SbnadDgvFXiy5h9MaA97U
	AfIPZnGJZd2TFxFX3t19bvqBoeOT5AonmVOQMTUfVHpc58U=
X-Google-Smtp-Source: 
 ABdhPJwNmL9pF8LrMeMTuiGhSazwzej8qijhF9UvPBDq5HcBevNvd/RkpDd/OeyBKxU/KoDO2I299jBewwlKaQaRqMM=
X-Received: by 2002:a05:651c:204e:: with SMTP id
 t14mr10334902ljo.499.1610971482320;
 Mon, 18 Jan 2021 04:04:42 -0800 (PST)
MIME-Version: 1.0
From: Daniele Varrazzo <daniele.varrazzo@gmail.com>
Date: Mon, 18 Jan 2021 13:04:31 +0100
Message-ID: 
 <CA+mi_8aZQXzB8Kr4V0nps3aMQ74N72uWC=pZF0P1H7AW4GLasA@mail.gmail.com>
Subject: Designing a better connection pool for psycopg3
To: psycopg@postgresql.org
Content-Type: text/plain; charset="UTF-8"
List-Id: <psycopg.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:psycopg@lists.postgresql.org>
List-Owner: <mailto:psycopg-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/psycopg>
Precedence: bulk

Hello,

I've been gathering a few ideas about the connection pool I would like
to provide with psycopg3. I would be happy if you would like to take a
look and give some feedback.

https://www.psycopg.org/articles/2021/01/17/pool-design/

Thank you very much,

-- Daniele