Re: PostgreSQL local connection is taking 4 seconds

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: Re: PostgreSQL local connection is taking 4 seconds
From: Thomas Kellerer <shammat@xxxxxxx>
Date: Tue, 2 Jan 2024 16:55:00 +0100
In-reply-to: <CAHkcXnyVu3HJSrzRu9KA0T9cLgJxSkHfW2tYJdBg+ozYxZy_qw@mail.gmail.com>
References: <CAHkcXnyVu3HJSrzRu9KA0T9cLgJxSkHfW2tYJdBg+ozYxZy_qw@mail.gmail.com>
Ui-outboundreport: notjunk:1;M01:P0:iFukeHYYOpA=;jTvXkr4MhsjkjVhyG6ZJxgVzk1r 1lIOEZaIl7eNjz9+LjK2IJizbBoHlyA2WV8xbXyfjKXivNDuzWc7Fuzunv7imDkCr6T13iMNJ KVGQ8CgFzAvLlnf4znrJb0XXsy1aLlIVws960E0EJftvmjqC2D2l8kC0qCKTagDQhMpartBCD k+3n5TBHZ/m2Zz4fTMExI0Vfy09VEnAOUdcQE6jYcFtMpz5/rSqpm1OggCfeCZICMYLoqsSmu YZh3DdhWxwNNA4nOSTEQpWzRNE5LeQpYhGVW6feCzgpLym22DtLE0I04CwLlNFBboHmE1q/XC GJed424RY7ptWm6eDiUk7IBnRv+8dLsh3+l4UFZS73+YXRmj5CpFGyuWjp/1ZW5AcuJW9UJ+/ 1wdRZub9Pg71JZsn6uNTkXDZdnzslTt3ul/gogrntvqqKyYLI0q+FEHpTbkQINFvGDM6pCqv8 h3ZfQRB+RAk6z6JuLI2vij9wrbvmMK7zFi89pgCGhrkWrIkYbBY3o3qARa0X5h5AJ+q8jV9VQ txCDiqm9YNOfTAmu/BOXd0wcPwKcCXgjVssFNfNg11TXRd0VNhGSs3K0PAdspOFaixbsXBR92 wfm6ER1wx/2g/4Q31TcCzXcUP19Ul73FE0QzY6FLv3TR2azQanaaMqt5FPsVcM5dnCj9igbQH jas5W+5uAiisg0LS5+y29qgRVyEwJHBBRyV3Xb6/Pfj/PMHSoRFpG1mcvs/jxI2zC1NcHM8wM OBi9FZn/8jpEX7kz7VdRH7SV4HouhwgiBmEaT5p8epkPhhATmw5F55+hDi21shaGZcLSpAZJu GZsQjXi75/x93iBFa+IegJxQbz5+CIy8ePUdBSTz3A3342k5rxM0r+r+EbQkXWkjIt1oC4Ehs EV7sGrZyfvC7LiaoAHDkhoj1PUyTXxMtyqzCWFsFzby1G286pNcCU0x9ciMJ8CrVo2rXMyre0 25dtQycgub6ZZEzmw6tqRnWvZGI=
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666


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.

Follow-Ups:
- Re: PostgreSQL local connection is taking 4 seconds
  - From: Tom Lane
- Re: PostgreSQL local connection is taking 4 seconds
  - From: pramod kg

References:
- PostgreSQL local connection is taking 4 seconds
  - From: pramod kg

Prev by Date: Re: PostgreSQL local connection is taking 4 seconds
Next by Date: Re: PostgreSQL local connection is taking 4 seconds
Previous by thread: Re: PostgreSQL local connection is taking 4 seconds
Next by thread: Re: PostgreSQL local connection is taking 4 seconds
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]