From: "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>
To: Tom Lane <tgl@sss.pgh.pa.us>, Greg Sabino Mullane <htamfids@gmail.com>
CC: Laurenz Albe <laurenz.albe@cybertec.at>,
	"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
Thread-Topic: Delays between "connection received" and "connection
 authenticated" because of localhost entries in hba
Thread-Index: AQHbKh+aHf1bKlFziUSkLwj47Vg/rbKe1GUAgAAMi+2AAHktAIAAB2uAgAAE288=
Date: Wed, 30 Oct 2024 15:07:32 +0000
Message-ID:
 <GV0P278MB041983236163E8B0755D089BD2542@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
References:
 <GV0P278MB0419EB5885DF99C5354804A9D24B2@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
 <376cac6e4ffe1dfb9f59f47a9652dfa49c033ec6.camel@cybertec.at>
 <GV0P278MB04198D3BBE5F475C75D34C74D2542@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
 <CAKAnmmKJ5PP4W=xDLsddoCUVGexOr_EVAG--jH7KGC-FBOB1Zg@mail.gmail.com>
 <567474.1730299755@sss.pgh.pa.us>
In-Reply-To: <567474.1730299755@sss.pgh.pa.us>
Accept-Language: en-US
Content-Language: en-US
msip_labels:
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=dbi-services.com;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: GV0P278MB0419:EE_|GVAP278MB0118:EE_
x-ms-office365-filtering-correlation-id: dcb0418a-b4f0-4d03-6240-08dcf8f49488
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|376014|366016|38070700018;
x-microsoft-antispam-message-info:
 =?iso-8859-1?Q?7RkMYWy0xcZSd8AbCrJYDGPpSvYoTQO536B/4XAb1iLnFSRu7YbGNdQnuE?=
 =?iso-8859-1?Q?HPGTwAJgTXivM0Db92HxPBYJ2D8IGG3juD/VZp2nGEMmBhs/HENN+ZS5Ny?=
 =?iso-8859-1?Q?GYsUketfLWjEzK7CXqWpILbX0KdlMmXm07y7gI2yNFQB+q+Xr9RkB/iltM?=
 =?iso-8859-1?Q?Pj27V8/t3dvkMwHRrNukQs3RQ/DNoEZt+qfg+UNTGUAums2jISyNwgzwRD?=
 =?iso-8859-1?Q?HLZhwhqL+ikhS7VDEvovJbineYxPc9lPBdh9nubr/C7YDkOPAcefW7SlCk?=
 =?iso-8859-1?Q?BupLScFMdRbGYvykz3+WJMnkzo7RIuRvPTVIGxg+TNyI6AenWvDBHMlFyu?=
 =?iso-8859-1?Q?L8okSkon0g7D/OBqhRF9KzsnaDCJOA3M4h/OFoXgFeQTu9oHGHvz4yPa2p?=
 =?iso-8859-1?Q?ym/9ZjZT6pW2Z1RvSawwtVjjGDzaY7KFSvOm7bnN1Ge6fFQghANfPe5IoN?=
 =?iso-8859-1?Q?PyNLc49Ctq43dOrmRrgbf5xcbcf4rl2qweCWliXKByh8zyLrFfM4qtPbxF?=
 =?iso-8859-1?Q?sl2LdWz09OjmAniBRbIDxe7p2RLp77I75bA5rFVQ40q4SKqcNO+krQr5qf?=
 =?iso-8859-1?Q?7EaPVcc/HgYQW3cIEa81DA2F7Jh/26K5s/ideYmxxeTg6T548SsHjI8ctk?=
 =?iso-8859-1?Q?mtDWuqKadTwBG94a6vK7wvQc32NjUCSZXX1AoXcOBvp0D9jZbc1tqUcEyc?=
 =?iso-8859-1?Q?QjmNBLbN5QynQftbgz/MX6BjIvA/u87PYmD604fkYTV/3HaOlyKgS8l+yJ?=
 =?iso-8859-1?Q?2Nm3BzVVEosOG/GNDmd0iRIjqsdOw9/SOkj0eHpoHU9FUN/IW1+yqBvO13?=
 =?iso-8859-1?Q?znJgdHJismTRPp5omGRls+NeaqKoXHjKzVH6TVGojKjZZECvqhn644v7N2?=
 =?iso-8859-1?Q?UZboLkFNpaxrgSLihNykM6M0Wd7CoS1qiinuJLyBMWlUZHTXAcvxiu/7+c?=
 =?iso-8859-1?Q?NY33dYbFUKT0fMyI6YmFBB8Es2X+Mcj8klXKSu2DmL0lcztDKXz3ccTj/q?=
 =?iso-8859-1?Q?MyidHDskc3FRx58flZMR2VoXri1bnDQZTkqnp5wy2vN780R6GBYlY6Od32?=
 =?iso-8859-1?Q?0dP0bXcQaCL0kQCfhNIQsZwwR8ro2jZMZWEzx6qihtcDyv2tRlTnBgbFPx?=
 =?iso-8859-1?Q?Oztv9TvREYoeLr6wgP3RzO1dO0nCEWzsemX1PpymWI9XV/8iPEPevtIYZ9?=
 =?iso-8859-1?Q?yX0isBubgfaPjXkcS3yJSirZ40A5GdWwjinxsQxUscgE9NWTpSN2WzWm9A?=
 =?iso-8859-1?Q?wTqImPak7XveyL6/P3c2Vb2C+lzAsKfBiGMtvgifFs1RO2FHgCBqOITVNy?=
 =?iso-8859-1?Q?0GgQOoh3OIkWk6FLneBrVjlCqa0vw5oXTI75GtT3nQWmar63HJglq8nPqT?=
 =?iso-8859-1?Q?5MPwxN70Vdh9moOLvi13zDB3mMSc+12j3wgd04yfcVno3C5t6axdU=3D?=
x-forefront-antispam-report:
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(376014)(366016)(38070700018);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?iso-8859-1?Q?/X2PqlWJdvyspWuzm2Pd/vo6D5eFipXE7D9u+FgygFAS5kUpqySyp1auou?=
 =?iso-8859-1?Q?4cB5pMr8y4lbDUvbV4Uthc9O0rvhyvmCzlHh0zFIrB4wXro8eQilnNbuJ2?=
 =?iso-8859-1?Q?6eUtuWh6Dexz4vAY1MIPwxiPmx0Z38QN6+fk2PdjddScsThbX2IVpFlf2e?=
 =?iso-8859-1?Q?TYoiLZ2FZ8wBk8zPdhVMnrmmuoJ3VnYWHSSXu4co/oKTJtFKubiqC7/zNX?=
 =?iso-8859-1?Q?Vz3HtjbFbPu2JyOuU0wqeVqg8SfrrTyS1c7bXNyakrqC4M6aYN7svrzcGG?=
 =?iso-8859-1?Q?5tbnddtEWFpA2zhq3kufpjj8fq0jqpPLcy3T3MLwXhlFwLcg4yAV3WUAuR?=
 =?iso-8859-1?Q?xOVEYF6+Pa6JX8aHcorL0HvWE0YOKq5FsfRxNry5OTKROtMwOcEQ0I4GYL?=
 =?iso-8859-1?Q?kZZdGJWBMWcrjYTSk8yXJKbGO8SybbWrYkpkIXILPeoRISWJs81lwe0SPH?=
 =?iso-8859-1?Q?qx88p4mECOBQGNBNjP2cE2x+9QIzL7plMMMYJVT2ntSnFZirFedI9II1Mp?=
 =?iso-8859-1?Q?IX0jaiw2d00V38xU40EeOVqcjqbnk5wNGm11P9QmIkVVLgfD3/xLsOupc7?=
 =?iso-8859-1?Q?KB7UoOW7u/EWLFRXrP6UhlsfxgbfkmMvLW5UB680ZjYWhVzdk37srt3W+3?=
 =?iso-8859-1?Q?SMbMZC/xuQIYLWFUKo4/B89MOoZsoahjOdeNN7dWug25NBa8k98LhyaOUH?=
 =?iso-8859-1?Q?CvBhcXC0qiDaWyNY48/AhN804QPNFjryttabedgQeNLXVTfvVewFVX4BAE?=
 =?iso-8859-1?Q?bJhuVJiKAhq+KmlEdMDClZ1u3FIzdG/reGzQO7y4IJqNfteHwDbaaI7eNU?=
 =?iso-8859-1?Q?d1sttbExW39wjX870pJR4I7AGivq2rxhr4CF8L1EqkZUrEtxnjsF6jawpw?=
 =?iso-8859-1?Q?Lvbgug9GqU2Ht+yLas1CQZPrROJ03KzZiKS52DMIVhmcRNSbXq2Te/+oAV?=
 =?iso-8859-1?Q?/JTiUoT+4S+wIMuNCDdcVm513q6DrR19qAaQrUvLexOjPL8xnQXZegIOKN?=
 =?iso-8859-1?Q?EjXQMCZ5MPx52GdCsXPbADusZX898dYcw/OdUuAo90SD+v7r33Le3+BW7b?=
 =?iso-8859-1?Q?UO2ilWmJSvhb23cHGdlFZMj5dGiLi5yiMlVDybEjv0cHBBZtVsjLhP/xKn?=
 =?iso-8859-1?Q?BtmZwFJQdxZcJi6Z29vKtOlrtMKgeJGR/Xsz2eN31b1IkG2lMDWua24hcg?=
 =?iso-8859-1?Q?/NJVaSSlkRePLtXNVMeUDKIYoS9HP7FH2CzOQcuzsUGJAk3easrMj5dF1b?=
 =?iso-8859-1?Q?1mgJB2rNJrHzF9/RtQjHY0PXq3zD2je20DC7PjSjyn5uCuu3GLenDmDmqE?=
 =?iso-8859-1?Q?Y0CgaUQw6tcBs1P6Q3ZrFC5V3iXBUhSJbsgr7pSQ2j+Zym7aEGAb8KWGx5?=
 =?iso-8859-1?Q?fLFaojhg7EQydoDPzSFXYd9rAbYtKjwgHK/DlvM4emSfCtDFRK4BPKSCkB?=
 =?iso-8859-1?Q?NDku2DF0NKs6G06u9fSccG8R1Tz4fX1/LCp0XWAP0cuD2zHAA5bpGvDLBc?=
 =?iso-8859-1?Q?COT1XkxPMQSXXopkTQWpKpJ3+8k0/EPQIQgUvUJ0vBfGJO+ICy2xdzgWrU?=
 =?iso-8859-1?Q?JAwCqiTOYTqMGZdIV1IL6KUj1wsEp3LWMtY8iTP2poAvdDaoxgzGEWRSNC?=
 =?iso-8859-1?Q?DLpj9ah+K4lRJY6RrhWMy4HbLXmRnuB3eyH8Jh3EmFVUMOBH6bWRhIyA?=
 =?iso-8859-1?Q?=3D=3D?=
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-OriginatorOrg: dbi-services.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: dcb0418a-b4f0-4d03-6240-08dcf8f49488
X-MS-Exchange-CrossTenant-originalarrivaltime: 30 Oct 2024 15:07:32.7080
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: b9c70613-b1ea-47b7-9fdd-e6f3a67ce75c
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: Zao0lHiG441UU0Sou0Rp24N9L1y0NjrKxZlETBHMMouww1TIvOtkjHJEZBMs6TGjEdzLiz0LD14NvIxqVK1vbHRPUECAw4I9oXix7ONMPBNy34fB3aeG7bbjB1lRBo+O
X-MS-Exchange-Transport-CrossTenantHeadersStamped: GVAP278MB0118
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/GV0P278MB041983236163E8B0755D089BD2542%40GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
Precedence: bulk

>>Greg Sabino Mullane <htamfids@gmail.com> writes:=0A=
>> I'd echo the suggestion to strace this. You can use the pre_auth_delay=
=0A=
>> setting to help facilitate that. See:=0A=
=0A=
>IIUC, the delays are rare and unpredictable, so that strace'ing seems=0A=
>unlikely to be practical.=0A=
=0A=
>If rebuilding from source is feasible, you could insert monitoring=0A=
>elog(LOG) calls around the name lookup (that is, around the=0A=
>pg_getnameinfo_all call in src/backend/libpq/hba.c).=A0 This would=0A=
>confirm or disprove the theory that the name lookup is the source=0A=
>of the issue, which is about as much as we'd get out of strace.=0A=
=0A=
Thanks for all your tips/hints=0A=
=0A=
Regards=0A=
Daniel=