Re: PostgreSQL local connection is taking 4 seconds

From: pramod kg <pramod11287(at)gmail(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: PostgreSQL local connection is taking 4 seconds
Date: 2024-01-02 15:49:45
Message-ID: CAHkcXnz96tcpne=mm2+VScUNcgodMAnNQWXrtYdeKu0PNRxK2A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

It's getting slower day by day. Two days back psql was taking 2 seconds to
establish a local connection. Today it is taking more than 4 seconds.

On Tue, Jan 2, 2024 at 7:42 PM pramod kg <pramod11287(at)gmail(dot)com> wrote:

> MD5
>
> On Tue, Jan 2, 2024 at 7:34 PM Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
> wrote:
>
>> On Tue, Jan 2, 2024 at 8:59 AM pramod kg <pramod11287(at)gmail(dot)com> wrote:
>>
>>> 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)
>>>
>>
>> What authentication method is used?
>>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas Kellerer 2024-01-02 15:55:00 Re: PostgreSQL local connection is taking 4 seconds
Previous Message Rajesh Kumar 2024-01-02 15:41:15 Re: Switchover