Re: PostgreSQL local connection is taking 4 seconds

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

 



log_hostname value is off:

postgres=# show log_hostname;
 log_hostname
--------------
 off
(1 row)

There is no change in postgresql.conf



On Tue, Jan 2, 2024 at 9:25 PM Thomas Kellerer <shammat@xxxxxxx> wrote:

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.





[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]

  Powered by Linux