| From: | "Daniel Westermann (DWE)" <daniel(dot)westermann(at)dbi-services(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Greg Sabino Mullane <htamfids(at)gmail(dot)com> |
| Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba |
| Date: | 2024-10-30 15:07:32 |
| Message-ID: | GV0P278MB041983236163E8B0755D089BD2542@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>>Greg Sabino Mullane <htamfids(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Don Seiler | 2024-10-30 15:24:18 | Index Partition Size Double of its Table Partition? |
| Previous Message | Tom Lane | 2024-10-30 14:49:15 | Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba |