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 1l1ZoW-0007Bv-K2 for psycopg@arkaria.postgresql.org; Mon, 18 Jan 2021 19:03:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l1ZoT-0002cT-Gz for psycopg@arkaria.postgresql.org; Mon, 18 Jan 2021 19:03:41 +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 1l1ZoT-0002cL-BZ; Mon, 18 Jan 2021 19:03:41 +0000 Received: from mout.gmx.net ([212.227.15.18]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l1ZoR-0001hl-7v; Mon, 18 Jan 2021 19:03:40 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1610996617; bh=OkJiZnH7+X48PU4Yh9wdHHa6uSZ6neEyGR1Vo2AaPYY=; h=X-UI-Sender-Class:Date:From:To:Subject:References:In-Reply-To; b=Z9794OVd1N/6ETTQviCiKffhyDB8WhTB+PnLzDnqI0o12nP8Qo52S+qpseL7RO7T6 gPeyyNEqk4nRkUrNw5Z8WKVv893D0Vi3HEVmOsntcsgblp93aD8JnZtxuoezDPZLzg 4ztwd3G0sncglORtdBvlFziWQEUHBZvx46OvNlvQ= 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 1MhD6W-1lfZCU2S0o-00eNrL; Mon, 18 Jan 2021 20:03:36 +0100 Received: from ncq by hermes with local (Exim 4.94) (envelope-from ) id 1l1ZoN-0000KG-HN; Mon, 18 Jan 2021 20:03:35 +0100 Date: Mon, 18 Jan 2021 20:03:35 +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:ew3+ddBf0Thswq74Y3wr7TpUVC70dpB70ouYnHiAA1Y+CP/NrEW BW1rY/lArfD+if+gj02Bf4po8VLI0x/eAQU2VuBZmhYSzEuHuYCvFVFPrGeR9IretbE7CPZ 4M2vv1FrAPNzPTo5e4IpcENMOkNj4wwpCPwVylBZKfUshTug8mGtxHkgciORY0pjZ0n1EkK S+qY0D6n6sSS2IBNAYfIw== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:BtP7Uevlwh4=:ay+g7oQTbpMMRWQd6hXU3Z jqA+5rCJec7iVf2I8so4QpU+Fv+HdFYGllSv2hWQRZosVS3oL0n1PlrW+2MGJZMUEKmJfJc5a mliMMyu+xrBZM092PPbtea62e4I7/zkvsZWYxQynEAvJ4nEEvHEGOr2NPV+GHWF0jSYTCGVfF cfzTgS7F6vNDG8M97biBDDSDBwnz5jGGpX6QSP1r371q8RKy9l6MuaILej9eMMO4qowNKQcpg hhCaQ2UlX/3irKQ0zUHmevHDUITJryz+C3G2JcDYQYTcOSsCLsj+lHvf++AfKjTTSVr8pGBQ6 CjXCRR5EKq9KoYXjzq73UwnWJEblYiuS/U+uy2hc9Dz4v6JY8tlgeNMz+4yGckfbgufF9C0JY OXvtnVfcO2p8IjbjxIzFAo0Ag43sG20FfFJQJQEjVIxjQ32tUfIYIlNo2smBm5hXTZVmDXZEC 1GE41AL01UGXSsajw8PuS0Z85g1jSswnAC7ug9Jynz/o1a/m8fAbAO/sxO2mV4DNWz1S0/6vW gzXhT9XqhOrWDD2ekrANvJfwkJz6AUYFESL9Jrm7Md/YrZ+BlfT6khfqMxs2gxXmUWDI7x8iq znZK3DyS/5wpma/9fv+UB1bkd6EDSI8WlHs/PNRYDOaJr9ruoJ00xFt66eWRod68dS/ak4/nc duqEVNM5MdZ6MotQU0mzgMcr/p14a9w5qXVlUD2DUyvLo11Ze83LE6FV6wBvc6t/tyI+HDJwa hE3TY2qEv6SE2SoGNI9jdRYVFSW9UfaiwLffjkumY2+nkiIm9BPdrv6xHH0VxvyYQl5BWl4Lx OyDV9fRuPg5514KuRgSwBxOwI2Yz1h44x0OA9cujtvy8IwFxiWlJ39+wCWNp+fslIs0dmSbcJ +eN+CrSWXrywBbpMq3lw== 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: > BTW, at which moment will the driver be trying to connect? At pool > initialization or on first "getconn()"? I tend to favor the latter, as a default. As you said, an application can always attempt to grab a connection early on to detect failures. Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B