Subject: Re: Interaction between "client_connection_check_interval" and
 "log_lock_waits" parameters
To: pgsql-general@lists.postgresql.org
References: <92db4d94-f836-ff49-01e6-294ea7709d9d@meteologica.com>
 <d5ecdfe6-c05c-4602-94de-70f9e474f865@aklaver.com>
From: Alfonso Escribano <alfonso.escribano@meteologica.com>
Message-ID: <aec86851-2744-fbdf-88cf-eb7aa2b75970@meteologica.com>
Date: Wed, 3 Dec 2025 17:38:28 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:128.0) Gecko/20100101
 Firefox/128.0
MIME-Version: 1.0
In-Reply-To: <d5ecdfe6-c05c-4602-94de-70f9e474f865@aklaver.com>
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/aec86851-2744-fbdf-88cf-eb7aa2b75970%40meteologica.com>
Precedence: bulk

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Hello,<br>
    I have test it with postgresql 17.7<br>
    I have been searching on postgresql src for commits related with
    client_connection_check_interval, and I only see initial commits in
    postgresql 14, I think it happends in all versions from 14 until 18,
    but I can only confirm on 17.7<br>
    <br>
    Regards,<br>
    Alfonso Escribano<br>
    <br>
    <div class="moz-cite-prefix">Adrian Klaver wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:d5ecdfe6-c05c-4602-94de-70f9e474f865@aklaver.com">On
      12/3/25 00:24, Alfonso Escribano wrote:
      <br>
      <blockquote type="cite">Hello,
        <br>
        I have seen an interaction between
        "client_connection_check_interval" and "log_lock_waits"
        parameters that it isn't documented (or I can't find it
        anywhere).
        <br>
      </blockquote>
      <br>
      What version of Postgres?
      <br>
      <br>
      <blockquote type="cite">Regards,
        <br>
        Alfonso Escribano
        <br>
      </blockquote>
      <br>
    </blockquote>
    <br>
    <div class="moz-signature">-- <br>
      <div dir="ltr">
        <div><br clear="all">
        </div>
        <div dir"ltr"="" class="gmail_signature"
          data-smartmail="gmail_signature">
          <div dir="ltr"> <br>
            <b style="color:rgb(105,105,105)">Alfonso Escribano</b> <br>
            <font color="#3333ff"> <a
                href="mailto:alfonso.escribano@meteologica.com"
                target="_blank">alfonso.escribano@meteologica.com</a> <br>
              <br>
            </font> <a href="https://www.meteologica.com"
              target="_blank"><img
                src="http://www.meteologica.com/assets/images/logo.png"
                width="200" height="16"></a> <br>
            <a>c/ Costa Brava 10 - 28034 Madrid</a> <br>
            <b style="color:rgb(105,105,105)">Office: </b> <a>+34 91
              456 10 01</a> <br>
            <br>
            <div> <font size="1"> <font color="#000000" face="arial,
                  sans-serif"> This email and any files transmitted with
                  it are confidential and may be privileged and are
                  intended solely for the use of the individual or
                  entity to whom they are addressed. If you are not an
                  addressee, any unauthorized direct or indirect
                  dissemination, distribution, publication, reading, or
                  copying of this message and any attachments is
                  strictly prohibited. If you have received this email
                  in error please notify the sender immediately, and
                  delete this email from your system. Email
                  communication does not guarantee the confidentiality,
                  integrity, or proper receipt of the messages sent.
                  Meteológica, S.A. accepts no liability for such
                  circumstances. </font> <br>
              </font> </div>
          </div>
        </div>
      </div>
    </div>
  </body>
</html>