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 1lFKgA-0005BA-Ed for pgsql-bugs@arkaria.postgresql.org; Thu, 25 Feb 2021 17:43:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lFKg7-0005Az-Kg for pgsql-bugs@arkaria.postgresql.org; Thu, 25 Feb 2021 17:43:55 +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 1lFKg7-0005As-E9 for pgsql-bugs@lists.postgresql.org; Thu, 25 Feb 2021 17:43:55 +0000 Received: from tamriel.snowman.net ([70.109.60.50]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lFKg4-00058E-Ha for pgsql-bugs@lists.postgresql.org; Thu, 25 Feb 2021 17:43:54 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id F21525F799; Thu, 25 Feb 2021 12:43:51 -0500 (EST) Date: Thu, 25 Feb 2021 12:43:51 -0500 From: Stephen Frost To: rich.crampton@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16897: gssenc request slow connection Message-ID: <20210225174351.GU20766@tamriel.snowman.net> References: <16897-2632c6541c9f8491@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="udzYTtuEmHLUHegf" Content-Disposition: inline In-Reply-To: <16897-2632c6541c9f8491@postgresql.org> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --udzYTtuEmHLUHegf Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * PG Bug reporting form (noreply@postgresql.org) wrote: > Email address: rich.crampton@gmail.com > PostgreSQL version: 12.6 > Operating system: client Windows 10, postgresql server Ubuntu > Description: =20 >=20 > When connecting over a local network from Windows 10 to PostgreSQL server > (Linux version 12.6 default install) the gssencmode=3Dprefer in libpq > connection causes a big slowdown. >=20 > With "gssencmode=3Dprefer" connection takes 4 seconds. > With "gssencmode=3Ddisable" connection as fast as normal. >=20 > As the prefer option is the default option this causes problems in depend= ent > libraries such as psycopg2 for Python. First raised the bug here > https://github.com/psycopg/psycopg2/issues/1242 but I think this must be a > libpq/Postgresql bug since psycopg2 is just passing along the request. What's the version of the libpq library on the client side..? In general, while there's an extra packet back and forth because Kerberos / GSSAPI is set up on the client / Windows side, once the server says it doesn't support GSSENC, libpq should try a non-GSSENC connection right away.. Thanks, Stephen --udzYTtuEmHLUHegf Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJgN+HXAAoJEO1sijiDR2RVR+sP/3iOaUuLIy3KXJM2NtdgPF4D Fx1fXIqTbNyFy2qOFjp5pII0ACHfg4fwMkbtLhtqz5EAI1cx/OCu4PlbTl2FjmRi kwDBEsm94jkYECwWwsWVnR5x+8bg82+L1EgdDFNqU8LKJDKQ8e2QHVM/4tzLJR9i leFS/i/f2iE0S/9ugs/i4HquRahzYzKaG9Lt6aosbRTR54+KMknf+h+tLfcQYUoC WWy+USx0Sfe9LbXPqnxgACONY/pXfBajDDVbmro6gShIH7d1DySDgRYHnmzstio5 3S2seJ9WwKppjI7Czv1MY0FJw0j0WFjok5r9QlFH4jX820GcXhrfrGogIHDPqF12 tx6jhsj7cwX412IIwQ24xJm3q2L8jk3wlP2+oaZvZ+4HE2c4TXVyup+H0LBdILC/ o03c/sagHiiYRxFqyJXBcF1VXHVfRyZmSwE3s88JNE7hLG303Fz5FCzlCJD4JQdA Xr68sEw9j0K4tAXxlcr5DJyjNi5EFLw7XEwfmj53hOt91KUH9QDW1kE38JlKYEpA Zc+eJOYMct1y+V6upEnAVNwrQ4Y3kj6IdVASHds3xmXOQIj9SPd7PnlDji8GXIAo 5ha7LKnpQ9eRpkGBBOr1tTuQwrOJJ1d+l3gWQVFCI+xNzsx8KH9U/gAUqfiEeM4d b4KQ50qibR08UPEaognh =VnWe -----END PGP SIGNATURE----- --udzYTtuEmHLUHegf--