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

From Thomas Kellerer
Subject Re: PostgreSQL local connection is taking 4 seconds
Date
Msg-id 006c932a-d986-d0d1-61cd-065ffbe71fb3@gmx.net
Whole thread Raw
In response to PostgreSQL local connection is taking 4 seconds  (pramod kg <pramod11287@gmail.com>)
Responses Re: PostgreSQL local connection is taking 4 seconds
Re: PostgreSQL local connection is taking 4 seconds
List pgsql-admin
pramod kg schrieb am 02.01.2024 um 14:58:
> Hi Experts,
>
> 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. 
>
> PostgreSQL version is 13.12.
> RHEL Version: Red Hat Enterprise Linux release 8.8 (Ootpa)

Did you enable log_hostname?

That does a revers DNS lookup which could be a reason for the connection suddenly taking longer.





pgsql-admin by date:

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