public inbox for [email protected]help / color / mirror / Atom feed
Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba 3+ messages / 3 participants [nested] [flat]
* Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba @ 2024-10-30 14:22 Greg Sabino Mullane <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Greg Sabino Mullane @ 2024-10-30 14:22 UTC (permalink / raw) To: Daniel Westermann (DWE) <[email protected]>; +Cc: Laurenz Albe <[email protected]>; [email protected] <[email protected]> I'd echo the suggestion to strace this. You can use the pre_auth_delay setting to help facilitate that. See: https://www.postgresql.org/docs/current/runtime-config-developer.html Cheers, Greg ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba @ 2024-10-30 14:49 Tom Lane <[email protected]> parent: Greg Sabino Mullane <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Tom Lane @ 2024-10-30 14:49 UTC (permalink / raw) To: Greg Sabino Mullane <[email protected]>; +Cc: Daniel Westermann (DWE) <[email protected]>; Laurenz Albe <[email protected]>; [email protected] <[email protected]> Greg Sabino Mullane <[email protected]> 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. regards, tom lane ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba @ 2024-10-30 15:07 Daniel Westermann (DWE) <[email protected]> parent: Tom Lane <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Daniel Westermann (DWE) @ 2024-10-30 15:07 UTC (permalink / raw) To: Tom Lane <[email protected]>; Greg Sabino Mullane <[email protected]>; +Cc: Laurenz Albe <[email protected]>; [email protected] <[email protected]> >>Greg Sabino Mullane <[email protected]> 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-10-30 15:07 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-10-30 14:22 Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba Greg Sabino Mullane <[email protected]> 2024-10-30 14:49 ` Tom Lane <[email protected]> 2024-10-30 15:07 ` Daniel Westermann (DWE) <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox