From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>
cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba
In-reply-to: <GV0P278MB0419EB5885DF99C5354804A9D24B2@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
References: <GV0P278MB0419EB5885DF99C5354804A9D24B2@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
Comments: In-reply-to "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>
	message dated "Tue, 29 Oct 2024 16:30:01 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <249663.1730221572.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Tue, 29 Oct 2024 13:06:12 -0400
Message-ID: <249664.1730221572@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/249664.1730221572%40sss.pgh.pa.us>
Precedence: bulk

"Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com> writes:
> we're facing a strange issue with delays between "connection received" a=
nd "connection authenticated".

> Has anyone experienced such a behavior? It seems clear that this is some=
how related to name resolution but we couldn't reproduce something like th=
is on the OS using dig (in a loop several hundred of times). It is also on=
ly happening from time to time, and not constantly.

FWIW, I do have vague memories of other complaints like this, although
not of whether solutions were found.  It was awhile ago though.
It might be worth searching our mailing list archives.

			regards, tom lane