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 1l1Zah-0006cs-FX for psycopg@arkaria.postgresql.org; Mon, 18 Jan 2021 18:49:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l1Zag-0008RI-DG for psycopg@arkaria.postgresql.org; Mon, 18 Jan 2021 18:49:26 +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 ) id 1l1Zag-0008RB-7n; Mon, 18 Jan 2021 18:49:26 +0000 Received: from mout.gmx.net ([212.227.15.19]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l1Zaa-0004wp-6f; Mon, 18 Jan 2021 18:49:25 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1610995758; bh=DE2Bzqria+au10d3ByWod7jTNDszT8YNvnvVCm5ERi8=; h=X-UI-Sender-Class:Date:From:To:Subject:References:In-Reply-To; b=HPDMFuU5zdhA8x0r1YQWd1kBpskgqDalLOtL++qnlPijk3rmL2RhK3zVhppUs6QAu dBKTtqnI/jRZDYrA3g+CpC/E+CjGQ2uk1uSoplrYSShR8LndGZKmlOSuzGGSS+dW+9 SW0BsWvD6lBl0JdQ9N1xpqy+TP/fR8Q3lHrhTkgA= 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 1MQe9s-1lMwUi2heA-00NeY0; Mon, 18 Jan 2021 19:49:18 +0100 Received: from ncq by hermes with local (Exim 4.94) (envelope-from ) id 1l1ZaX-0008LE-St; Mon, 18 Jan 2021 19:49:18 +0100 Date: Mon, 18 Jan 2021 19:49:17 +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:OS2kixmwDOMkoSZO1Rgbg7YEFj3HtyOjKl9QqWMYZxwvlK+e0LH u7xNgxdwsC48/dd+sI87nBAgOmVxWVqOaf/vDsi8ZkzPnn5BZo1HptynYZa46UK6iyRXc+f voFjzNhTlaWM6rrfAY03E8M3JwmRq3bQ8ZYUnX/2hXftyINAyPWuVFtn5GaQrvieNlqflyg 8vdwIGLA9rCZwbt6ehaPA== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:9vyv7ZX++YI=:8xCATa/9VWCYzN/ujUBy28 z5C5I1hu550e5R//KdVmE4/wItY0Fz0Og0u9W4mVolyDPCyCFseuLgKQkmdsjcy8cVldlV5fu aT1HsVNnUOgSQEoDTDYES4OKhrjIEARir1kH5ACJaYoV9JNbLjIBWYt0e/368mxHnuRoe84XI kVTbHsZ5e086mMBwdnV207JAgptNMyHcMyl6G+EfFdX3eTJlu485XlWR1vbAX8qddpOBqKMpZ S9GA9GbhBbjGrVrIXPL2rdoL/HbJGgX80fnlBG1G8LeEXM4hZtfoYPIbBRvduJ8X+2Zswc4xJ +jIH71hyj49H9NDaTyyhIrRMsPwNjRexryq3vXeOBiaCjPDmTUowLmbb9TOVQ9hUYI/sIjqy8 NJOqwspjaz3Dc5eOQgvPNryEO5oVhEp2zVYK/ny/rvjUaEzuNWcDwam8MHj3OytHw/9e9zNC7 NB4etiAWBu3VDpcsF7sru/C6e0T7Z/NJRwm+mnBhzkR6Z2eMWhEl9F/SX1QzLCGqfWGp6uENI k1KjNllaY0v3+QfE40Smywho+QimCFzuSa06Xk8CFoC5UijH3K3nfCA8wgiWq64uF0JmoaN3S gAzO47TT85Wz0nUv3N4QrkfO0PqUig8arlH17KPxqWKEfo1pcCHj1ReAIUgO2/gMkQZcTCIuV gzO7OCWIN5ndKhPMFjP0wrFRcwXG1yzTWR+ZFaH2t8cv9TSgvpCi2m9xgD/t28EnYoiq1RE9j /7a6fJgiuxFdXOPmZwSbFQkKjTEqwC4973amTocNShx4SQ6kR7LK1NN3ht2WFNT7iPdLCNwWt nymsiN1k2Pq0FyrO3IYEIpFSINBAI4VabhheuYRupPc8WwT+DXxTyf5cDs93UcnuaSxIC9bMB vWLSgqYJCNesW8lW9G6SrpQqZ3Gg9kgYf+Vh8/09g= 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: > > 'minconn', Proposed default: 4 > Many services and applications do not really need many connections > but would like to benefit from automatic reconnections. So the default > is questionable, as many people will leave it unchanged. I would, perhaps, default to 1 *per thread*. Or to 2 per thread, one readonly, and one readwrite, if the application cares (requests ro vs rw, that is). But that's just me and my use case :-) Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B