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 1vlNO9-00AaQe-32 for pgpool-hackers@arkaria.postgresql.org; Thu, 29 Jan 2026 08:28:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vlNO8-007Gti-05 for pgpool-hackers@arkaria.postgresql.org; Thu, 29 Jan 2026 08:28:28 +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.96) (envelope-from ) id 1vlNO7-007GtX-2c for pgpool-hackers@lists.postgresql.org; Thu, 29 Jan 2026 08:28:28 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vlNO5-002sww-0W for pgpool-hackers@lists.postgresql.org; Thu, 29 Jan 2026 08:28:27 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Transfer-Encoding:Content-Type: Mime-Version:References:In-Reply-To:From:Subject:Cc:To:Message-Id:Date:Sender :Reply-To:Content-ID:Content-Description; bh=RgvgRCUyA2Q2xfmQsm8zq1NpQUo9wEq68MHUouc1npU=; b=HbvtcD+4QZm4DZKgrxDASutSR4 ye3MInNtMseXijk+tFmN6fbr/Yh9FzulPo2xyKW/zBfWtJizNfjStTw+ChuU//ghXtNY65oCy3Kl/ QXfLcYnI1nVwN1k7UTMnmrbpwjFNE9FYbBMbivpktdJnE02skMpmLcNlb95+3wI4AT9ZJUktltony dDzMNdY8hRSAuag8AKqkJE4l8hJQSy5LNUt1iTRru/z+sy+Xake+5k/UTcHWs+6SVsLxUHC8m9t5i 4GOjA+XKzDa07GLnogTk16sAP4XRPLPy3yp9Zw4T9vyQoc/B3LLEGZevoPsVJe7cBcDjXeaAchbtx Pi0cS5oQ==; Received: from 117.141.178.217.shared.user.transix.jp ([217.178.141.117] helo=localhost) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vlNO1-006fli-39; Thu, 29 Jan 2026 08:28:24 +0000 Date: Thu, 29 Jan 2026 17:28:10 +0900 (JST) Message-Id: <20260129.172810.828658334363427861.ishii@postgresql.org> To: nadav@tailorbrands.com Cc: pgpool-hackers@lists.postgresql.org Subject: Re: Proposal: Recent mutated table tracking in memory From: Tatsuo Ishii In-Reply-To: <20260128.140840.463288103359200425.ishii@postgresql.org> References: <20260128.140840.463288103359200425.ishii@postgresql.org> X-Mailer: Mew version 6.8 on Emacs 29.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > Hi Nadav, > > Sorry for the late reply. I just your email now. Will check and reply > back soon. Unfortunately your patch failed to apply to current master branch. $ git apply ~/mutated_table.patch error: patch failed: src/streaming_replication/pool_worker_child.c:1032 error: src/streaming_replication/pool_worker_child.c: patch does not apply It tried with patch command and it seems failed here: --- src/streaming_replication/pool_worker_child.c +++ src/streaming_replication/pool_worker_child.c @@ -1034,6 +1036,10 @@ check_replication_time_lag_with_cmd(void) bkinfo->standby_delay = delay; bkinfo->standby_delay_by_time = true; + /* Track maximum delay for memory map TTL calculation */ + if (delay > max_delay_us) + max_delay_us = delay; + /* Log delay if necessary */ delay_threshold_by_time = pool_config->delay_threshold_by_time * 1000; /* threshold is in * milliseconds, convert Need rebase? -- Tatsuo Ishii SRA OSS K.K. English: http://www.sraoss.co.jp/index_en/ Japanese:http://www.sraoss.co.jp