Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rKh6i-00447X-SS for pgsql-admin@arkaria.postgresql.org; Tue, 02 Jan 2024 15:55:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rKh6g-00Giz2-O2 for pgsql-admin@arkaria.postgresql.org; Tue, 02 Jan 2024 15:55:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rKh6g-00Giyt-5J for pgsql-admin@lists.postgresql.org; Tue, 02 Jan 2024 15:55:06 +0000 Received: from mout.gmx.net ([212.227.15.19]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rKh6c-00DOJd-U4 for pgsql-admin@lists.postgresql.org; Tue, 02 Jan 2024 15:55:04 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1704210900; x=1704815700; i=shammat@gmx.net; bh=COHfZw1emsNdiiiPN/+HHSWBNyx7w460N5hoAVAmQwg=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=HKE/Fb4kFDZyyWrwF1UJaEQzDnRHmx1fal9XdwI+5J6f0bTcjGE60oC9wN0NjAFv CSI30KAj1vbCXLTvLVDE7ZwticgpZjP7AdY8gzAoRcYdO/BW7SlDPb4WNSgjJWcm4 9QaIuSwJj5AgkRUahQGY8fhtqFEObpcmx2oFo81OUU/Uau5onqCNF4A7wKGB8FGq2 LcH+EtE7eV6uNrf0vT31t++83H9qCxVam9apdFR+GY0aeoWp+YlUsDxmfmEgZhtS6 g0CWCWfEsePDHMV/qNsmnUWxGYidIQREAfyT7IPfNG2/KMWSuai95YUbmWFVMRg6x jgv6IgdhTLXxw3wA5g== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [192.168.178.20] ([88.217.180.228]) by mail.gmx.net (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MMofW-1rbGYC1JbA-00Ijib for ; Tue, 02 Jan 2024 16:55:00 +0100 Subject: Re: PostgreSQL local connection is taking 4 seconds To: pgsql-admin@lists.postgresql.org References: From: Thomas Kellerer Message-ID: <006c932a-d986-d0d1-61cd-065ffbe71fb3@gmx.net> Date: Tue, 2 Jan 2024 16:55:00 +0100 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 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: de-DE Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:coDtONb1LRN8sjMvCPx/y7InMQLlNREnf34i6rcJfiNj+rOpkOt L2i1Wa8Nt/MtU9NYqudQYr4LnTEcDFIK7zpGOIIRD+U5nyhcJSCDHHFRcKaLgWNXgkPOxZg Hg7A/DAzOEtFfZ8dphGHd+tzih0xyDrSIpzj5kjgYpYZYI+bq0sWgvaeqTdcrD/zlxpm6gn ijY6axG9UPq22VMkmTF0w== X-Spam-Flag: NO 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= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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. Aft= er upgrading, PostgrSQL=C2=A0local connection is taking ~4 seconds (Both T= LS 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:=C2=A0Red 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 s= uddenly taking longer.