Re: PostgreSQL local connection is taking 4 seconds

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL local connection is taking 4 seconds
Date: 2024-01-02 15:55:00
Message-ID: 006c932a-d986-d0d1-61cd-065ffbe71fb3@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.conf or 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message pramod kg 2024-01-02 16:04:41 Re: PostgreSQL local connection is taking 4 seconds
Previous Message pramod kg 2024-01-02 15:49:45 Re: PostgreSQL local connection is taking 4 seconds