Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba - Mailing list pgsql-general

From Daniel Westermann (DWE)
Subject Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba
Date
Msg-id GV0P278MB041983236163E8B0755D089BD2542@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
>>Greg Sabino Mullane <htamfids@gmail.com> writes:
>> I'd echo the suggestion to strace this. You can use the pre_auth_delay
>> setting to help facilitate that. See:

>IIUC, the delays are rare and unpredictable, so that strace'ing seems
>unlikely to be practical.

>If rebuilding from source is feasible, you could insert monitoring
>elog(LOG) calls around the name lookup (that is, around the
>pg_getnameinfo_all call in src/backend/libpq/hba.c).  This would
>confirm or disprove the theory that the name lookup is the source
>of the issue, which is about as much as we'd get out of strace.

Thanks for all your tips/hints

Regards
Daniel


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba
Next
From: Don Seiler
Date:
Subject: Index Partition Size Double of its Table Partition?