Thomas Kellerer <shammat@gmx.net> writes:
> pramod kg schrieb am 02.01.2024 um 14:58:
>> We have upgraded the OS from RHEL7 to RHEL8 in our testbed machines. After upgrading, PostgrSQL local connection is
taking~4 seconds (Both TLS and non TLS connection). Please advise on what to be verified? There is no change in
postgresql.confor pg_hba.conf.
> Did you enable log_hostname?
> That does a revers DNS lookup which could be a reason for the connection suddenly taking longer.
Even without log_hostname, it could be a slow-DNS-lookup problem.
Rather than guessing, though, it might be time to try strace'ing
the psql session to see what it's waiting for.
regards, tom lane