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 ) id 1l1ZX1-0006UN-ES for psycopg@arkaria.postgresql.org; Mon, 18 Jan 2021 18:45:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l1ZX0-0004WM-B3 for psycopg@arkaria.postgresql.org; Mon, 18 Jan 2021 18:45:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l1ZWz-0004WF-R2; Mon, 18 Jan 2021 18:45:37 +0000 Received: from mout.gmx.net ([212.227.15.15]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l1ZWt-0001Yx-W5; Mon, 18 Jan 2021 18:45:36 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1610995529; bh=P/cKUucUQur1Fdzty6/fEmwDHji75j3CWkZ57pARldY=; h=X-UI-Sender-Class:Date:From:To:Subject:References:In-Reply-To; b=BPOcQpTrDm1y29Yn3PARKrBisHzDhPfFeomJgqs3+2VPQgQVeZuE4MEm+rsklefEk xyEVRgD0NReAGUOBEV9L+GQ10UlyXzEE6M9IwssfXPUCe9Oqzz+zQUpNB0EHjZo0aQ qtLSvgV62XChwH7jgpyPfNHN+b1Q30sHT/R4HPCM= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from hermes ([89.12.167.206]) by mail.gmx.com (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MBUmD-1lBmXn3kVD-00D3Yd; Mon, 18 Jan 2021 19:45:29 +0100 Received: from ncq by hermes with local (Exim 4.94) (envelope-from ) id 1l1ZWp-0008I8-Nh; Mon, 18 Jan 2021 19:45:27 +0100 Date: Mon, 18 Jan 2021 19:45:27 +0100 From: Karsten Hilbert To: psycopg@lists.postgresql.org, psycopg@postgresql.org Subject: Re: Designing a better connection pool for psycopg3 Message-ID: Mail-Followup-To: psycopg@lists.postgresql.org, psycopg@postgresql.org References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:iA25w6QSmefOl9y8Kk5VtL6Y17svov51bkdU5xfwHI5DMumlzMA Zsj6bWRmSjMndch+ltRRftjgraqs1BqW8DyVgta4aJfmDoxRosLqiFlSLhR4gFfchFlG0nL yGQYBPi/NZ7zSAJbeqIBHym3tZ6xgeOgBj9enoTD4IcUQq6fv51DedH6pnJMkhFaDd0zEJm UEK48UiOHST8NhnmSlQ8w== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:JHRe67msxxE=:sjGX23aRZ5zensnSwxnn8V 71jbumLGVowLVN5TXqgQrGbXuLgkoB2EyJxm2Uz1/Ejyv+j/qmgK5QRK7fkneAmo75AgYUSeU 2hmnoXFVmG+CPRzSnwi9UBPhFZKnGLODAQYq9UuQC7un1Kwp8AmJt+Xxj8QDhw2zuXGGCr2kZ NEoUkExLhmAFnuCIe+Lx6FRiP7VMjdYDDA8poQFFcHwYr3Iyc468xIPOS96KqGp2x4zOfpZ6i QUUAttqcZXMQbUhLaHB4aJqYjhU7J5+AhThoN7e9CkV+TfboGFsvpcC6w/0wSxpoStmUFCyr0 4otxLDZ/vbJGBocJb2NVZZ+kdLEkWEiTwMXMEctdonWt94Mgu/9UUiCMytlnrLk0BJutEzbB3 MTCrbbLmFXfGDUlFAeNlMElkmSE2mefUVKTs8HcHRTaSLRDR9ImqWh3kQ7onHL2oUc4VOHmXY lYeEOwaeEvPQooyv0CjQJi+DBrLgFJ5H8+1kjIEz43zDt4rBT3V1B66CnGeQsfKGoaOLi7n3Z Nn8+Y9y0W+UqNwVql7nT4NTRasACUAZiowNZNkU1jaXxxcx6N4CVknrHJmtiaJHBM25MEekQu grYWEpDBsEpFs6a4vGGUPERo67kin3H8s85AhH2hnRN2MwVRcwu/CtHVJu+9LJB0WMIIZMYws dbuwMc1oxHYRcyY7fkdePOGQKeoIPik5TSzm8G1d+SJcDT9AX+hzEy0QpvHFLf7B8Exa7QgcS ukOiGDoOUH/bXlowxXyoR1JfiIZlI0aaDTUNo+gqL8Dsw2Xgk4EZeNnZehQNtbWZQTQuk+g8K HzakM63POUJzqzxPmx7r6ld+AzQE3g3ySeU3myV8JTcacP/9LmoAcgX156mIXHRZQ8SC109uE w/UokN47CC2rgoD0MvQmYtiSE6V/phmdUH95OrO+Q= Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Am Mon, Jan 18, 2021 at 10:20:12AM -0800 schrieb Vladimir Ryabtsev: > > Exclusive connections? > The feature itself seems useful, but what are the benefits of getting it > from the pool (e.g. checking state, reconnection, configuration) > as opposed to creating one manually? It might decrease the necessary import surface. Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B