Re: PostgreSQL local connection is taking 4 seconds - Mailing list pgsql-admin

From Tom Lane
Subject Re: PostgreSQL local connection is taking 4 seconds
Date
Msg-id 4096247.1704212846@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL local connection is taking 4 seconds  (Thomas Kellerer <shammat@gmx.net>)
Responses Re: PostgreSQL local connection is taking 4 seconds
List pgsql-admin
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



pgsql-admin by date:

Previous
From: pramod kg
Date:
Subject: Re: PostgreSQL local connection is taking 4 seconds
Next
From: Laurenz Albe
Date:
Subject: Re: Vacuum