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.96) (envelope-from ) id 1vdi7w-003lmz-0B for pgpool-hackers@arkaria.postgresql.org; Thu, 08 Jan 2026 05:00:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vdi7v-000HVq-0C for pgpool-hackers@arkaria.postgresql.org; Thu, 08 Jan 2026 05:00:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vdi7u-000HVi-2h for pgpool-hackers@lists.postgresql.org; Thu, 08 Jan 2026 05:00:03 +0000 Received: from mail-yx1-xb135.google.com ([2607:f8b0:4864:20::b135]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vdi7r-005DG7-0d for pgpool-hackers@lists.postgresql.org; Thu, 08 Jan 2026 05:00:03 +0000 Received: by mail-yx1-xb135.google.com with SMTP id 956f58d0204a3-6467ac59e16so2167921d50.1 for ; Wed, 07 Jan 2026 20:59:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=tailorbrands.com; s=google; t=1767848397; x=1768453197; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=cYlqAuapt8pCb8klwvew1l8yEbF5wblMQqCJMVZpL10=; b=XT00QuBhAog5UkM5xNjETqlXcWCtzlmzxevrbNJOegs+bNnEeAkhbtBUiwSnZDJzdb TNVNEkU9mVv8zdUTwtty28IWl7GWjym5wImt6m5JhRAFkz89P66tDT5Myf+r7rk3U517 TNjAAsctjHDh/gKnxN+6GSIt452Bv+3cul7gvBA3LlsICf+SDb1ajEU7lR7Hz6YTDWiu CIIflgjldTvZpPQ6RikmveRp6FzK+UYixkzq6HzNfxg7vk12Yw+VMF5boEwjjOS8YjWz 4X8DTLQAxzoorx/uKF53oDcOOx8ZHaPGNPnk29rThYjl0O5NSIseBqHN8eD7fLi+A67/ I20g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1767848397; x=1768453197; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=cYlqAuapt8pCb8klwvew1l8yEbF5wblMQqCJMVZpL10=; b=rVemDRB1pV577GP1IUF8PWvEOYkLbZZA0cvHWDvqhI+iWKdlH0/i3Z1O4BM9hYFAs4 r716uLBQzPfnA+bWbdc0N0I6d3SuyPwU7U0P9CglUN6hKcY5tVXqrpaXwssOzPU+J8+j VcdpLHDtkLi+ZqZQpCFdztVvxN9Dlu7M3820lO6fO0SXabFJ8hirGRBjKk7ikQdJUPig x0b82IjarUN/srsJl5mtJJJre7tKlbtb7omjmVIZPZk87J9hFFitOQ4NUaL6w+IV0aTT VvNK3suj+C5m9zqcdAHMYGYU8jMRjI9GVFAtYaKLhh/1cvNDgXWyPWBolcFYD1HRmZBL 3YKg== X-Gm-Message-State: AOJu0YyW46KF5cTN6ws5M4vI5uVmrM4yBOlZB//OyNbuqPFTsjHhRfQv hrQNaaKsAexv+DbdOMqHhLiz6y7luDoxhzbcBUt0qq0gkKFfpIBGUjojluq+7EiJ0S1/h0Y8SBQ XYDde/pax7SzW4EeRD2lpEBaoiUyyYPEY88WyS5de6A== X-Gm-Gg: AY/fxX75LzDKxuIhcdKFmDA1aT6sH06ADt+q+AIjIFD4LJhawq0FeA/fC0rQK8r0wHo TofKb56Ee99oq7Ni9PSbh20K42fPYkOgR6+P1JQmrhYUJwQAvpzM/NvTAJhg+BXrlmGD7grY5C9 Hsh7IIQGwa+wR6pwORkPFhzwvztiIQKiHvf28xO5JJ+DmmAwS2B/a6Z7oDoht2Bw2PddszezbQ/ ryEK9YkC7eVfuavNmeiWv7ucpt+aWDdJ5LDf7k4UGZhlurnj4iGPizic5/6sWK22s13HBUiSouk mq+3mO++YjIDmCrUK7hWpgLafYt4vpSkCJIbXgJh+sPNZp2AcKYi8FJ8fWnqEaxqoS77ux2EbEQ eyyUfvtgbXfXS21CAzp2FqM1Ujg== X-Google-Smtp-Source: AGHT+IHok+RTCIcYhox5vPx4zkYpxkQWqLNNy3UlEUPlp9SHqh4LhCEuOWX8As/0nW+8/mxkQBbcwuu4xIpeLeaWHCY= X-Received: by 2002:a53:cd4d:0:b0:63f:ad02:8e2 with SMTP id 956f58d0204a3-64716bda129mr3370738d50.31.1767848397212; Wed, 07 Jan 2026 20:59:57 -0800 (PST) MIME-Version: 1.0 References: <20260106.134808.2204131019902796784.ishii@postgresql.org> <20260106.154320.1734616587238293334.ishii@postgresql.org> <20260108.111911.1930855426356010993.ishii@postgresql.org> In-Reply-To: <20260108.111911.1930855426356010993.ishii@postgresql.org> From: Nadav Shatz Date: Thu, 8 Jan 2026 06:59:45 +0200 X-Gm-Features: AQt7F2pPzSIYSB-gfYBkD3i-3k8o488W9UDDJNz-LgktQLFZAUT5VmyC3gSyPao Message-ID: Subject: Re: Proposal: recent access based routing for primary-replica setups To: Tatsuo Ishii Cc: pgpool-hackers@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000bbae030647d94741" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000bbae030647d94741 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Much much better and cleaner! Thanks! Nadav Shatz Tailor Brands | CTO On Thu, Jan 8, 2026 at 4:19=E2=80=AFAM Tatsuo Ishii = wrote: > Hi Nadav, > > I have just noticed that check_replication_time_lag_with_cmd() can be > simplified by using StringInfo functions. Patch attached. What do you > think? > > Best regards, > -- > Tatsuo Ishii > SRA OSS K.K. > English: http://www.sraoss.co.jp/index_en/ > Japanese:http://www.sraoss.co.jp > --000000000000bbae030647d94741 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Much much better and cleaner! Thanks!=C2=A0

Nadav Shatz
Tailor Brands= =C2=A0| CTO

=

On Thu, Jan 8, 2026 at 4:19=E2=80=AFAM Tatsuo Is= hii <ishii@postgresql.org>= ; wrote:
Hi Nadav,

I have just noticed that check_replication_time_lag_with_cmd() can be
simplified by using StringInfo functions. Patch attached. What do you
think?

Best regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
--000000000000bbae030647d94741--