Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba

Поиск
Список
Период
Сортировка
От Daniel Westermann (DWE)
Тема Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba
Дата
Msg-id GV0P278MB041983236163E8B0755D089BD2542@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления: