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 1l1ULk-0002Fr-Un for psycopg@arkaria.postgresql.org; Mon, 18 Jan 2021 13:13:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l1ULj-0006RE-UM for psycopg@arkaria.postgresql.org; Mon, 18 Jan 2021 13:13:39 +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 1l1ULd-0004w3-CS for psycopg@lists.postgresql.org; Mon, 18 Jan 2021 13:13:33 +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 1l1ULX-0007OP-7t for psycopg@postgresql.org; Mon, 18 Jan 2021 13:13:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1610975603; bh=dbLOEaRNqyJ8D43z6G6rxhA+xBRGS2seWb2C1coBb8M=; h=X-UI-Sender-Class:Date:From:To:Cc:Subject:References:In-Reply-To; b=JCTSAipJU05+LCyofLkyM3HX6ZFJceALkYwXARS6M11KY8WlI8nrHQvalo9yqWrLX Lo2Ibnozy4Ie+O3bLe63Zkf0B44iLwwNvRib+fbVOYiohZhXGVo9gqaoWeG8ba2djg qis1uhQk8lmoaluHfCcHjDQJbJTRSCul1Mdl6Bp8= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from hermes ([89.12.167.206]) by mail.gmx.com (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MrhQ6-1lmhiZ1es8-00neEa; Mon, 18 Jan 2021 14:13:23 +0100 Received: from ncq by hermes with local (Exim 4.94) (envelope-from ) id 1l1ULR-0000aG-P4; Mon, 18 Jan 2021 14:13:21 +0100 Date: Mon, 18 Jan 2021 14:13:21 +0100 From: Karsten Hilbert To: Daniele Varrazzo Cc: psycopg@postgresql.org Subject: Re: Designing a better connection pool for psycopg3 Message-ID: Mail-Followup-To: Daniele Varrazzo , 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:6ijjYDGXMnf10G9Qyo0RcyPRpqqDkNOVX4enQcJn0SEuBowuKxD dlNe7ml0FnsA68An6JyRRS8f+N87I/yV9yWWEPt8I68YJpnJdLGo1SaDF3+b8No7yiuwLDC fQhSFmqa+/kWg/CgSPOul3Gb7RVUtiohCiYv9bLqQkP+S2SZx9R4cw77+JLmOg758S0UVKK w75k/050gAjThZLOTRcug== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:mVRReGu4nVY=:OQhZ0zGonGhWF4cncBtUe3 bCc3lgNlCzetA/BCXl5GZaJLLEQ+3+NYUV/hC8+XVxegE79YmVLLQJBiM5gl4AscMcTMoxSYg g3JjTnDjfVzXbsjHj4wFzn60Bsm7YPdEDuI4IuZdkfnkMySfT8VA1vL0U6YZkg2I2V6sLhhTs tvsFa01TbULjIFYH3J+XFvT9r8MVD8fWoSrP6XEeJJUnXO0x/F0nP264wDnE/UkhuHtBC7D/T uVknevjZ53JtjUZcs0FLNQpgj1Kr3k1ppoNV31uXPgl8cVhA3oXpj868VHioAIHLbifeW3Pnt yNO4/H4uLXV/lOWAUC43C858r9KYpQTBq7VM4lTEUXApuJHuIXVWvpCRI2hNZwptOs63GOG+7 LLIeK45mi1Kch2ki7xlsljQTT39ma3HFWszrs9nS7AvVChhNH2IP1arLCQxHcHtYAiXLysX2y vZn1p8RHf2SPkHdOVlA/AZ7ZPZlKKtmNJFlv5dpPw8rB9asrWVPZpeumxoIvGx1oYiB2uPB/H 3ZOZ/DDMRowIZBI8qXZheMgQcASe/qI9veij6OeZzpc5k2b/A27UwbmtsvxP+7Olpu8zvaTWp QvlvwFOQdv+gTZUxhfiGsZSCAVCmadGjHcvSD3AJixKxDS5r0ysDvIQbHOfbZb6H2lhBO+k3Q pXb3j/V+zQZe2QvaWb517/duDgrChdeV29H/u0y9JjrJMtxWu3C1MGsHCvBuY5FF2MDg285/g 2a03giDWnkSH6e4Xn9V9mV6f1g53AmvCB0VOaBMKhFVNHmE6utVJjClUAsAki/r8wpMyq5tob ET5vDUBlR27J1uJtn/jmUc+vVrTXjIUSb3gLpNgUS++kg+66R6fjk67ngFPOSOWZIOhI2hCKP /gPCtWt5iKOf5KcasYvA== Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk > 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/ I would strongly advise against making sys.exit() the default for pool.terminate() unless I misunderstand something. Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B