Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mJDfQ-0001XU-KF for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Aug 2021 11:35:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mJDfP-0004Ri-7t for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Aug 2021 11:35:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mJDfO-0004RY-EI for pgsql-hackers@lists.postgresql.org; Thu, 26 Aug 2021 11:35:31 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mJDfL-0000Zq-18 for pgsql-hackers@postgresql.org; Thu, 26 Aug 2021 11:35:29 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id 5FA5332003AC; Thu, 26 Aug 2021 07:35:24 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute6.internal (MEProxy); Thu, 26 Aug 2021 07:35:25 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; bh=TtY7mJZe8jaGexs5ow6X68gYcxKJXjTRqsqA0Dpdm 4Y=; b=qSmmAFgrGz+pox2+VLfRZDf4R/iZzyDb1q+LKd6pIWoqRtYQdSope6XhA Lr9Cnl1k+01WVQeLeM+RmD/ZhVzCYwPrNt7Dh9+Y+WWZBlCTQbv/H30UeivoQTlq GoheOUb7EpiBejku+rB4OGc+yLn+323OGVo5gyDPPSgjm4YhkbpiwCnQpulgL0er /P+DnbFLv6Qd3+cmdXGYqvuRUtPL3FD6Ul2yHCiO6+g6kidPWzUjeee1i8AzKy8z 3Yal23vJZL3FYLvPXsvf9BksWgL9YoiaAOu3CfDWKgG4vDGY1mcG7a2cnDz4Y5Sq CC5URI3OaVdwRIxwUOUuVUCNzrWdw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvtddrudduuddggeduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepuffvfhfhkffffgggjggtgfesthejredttdefjeenucfhrhhomheprfgvthgv rhcugfhishgvnhhtrhgruhhtuceophgvthgvrhdrvghishgvnhhtrhgruhhtsegvnhhtvg hrphhrihhsvggusgdrtghomheqnecuggftrfgrthhtvghrnhepleevheehueeiudeiteei tdekueetleefteejffeiffdugedvffdvffdtiedvueeknecuvehluhhsthgvrhfuihiivg eptdenucfrrghrrghmpehmrghilhhfrhhomhepphgvthgvrhdrvghishgvnhhtrhgruhht segvnhhtvghrphhrihhsvggusgdrtghomh X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 26 Aug 2021 07:35:20 -0400 (EDT) Subject: Re: Minimal logical decoding on standbys To: "Drouvot, Bertrand" , Andres Freund Cc: Ibrar Ahmed , Amit Khandekar , fabriziomello@gmail.com, Alvaro Herrera , tushar , "[pgdg] Robert Haas" , Rahila Syed , pgsql-hackers References: <20210407170954.xbovgh3xdrnogg7w@alap3.anarazel.de> <20210407203218.pestfxu7watrnog4@alap3.anarazel.de> <20210408034713.auf7oaxyymu2kc7n@alap3.anarazel.de> <26c6f320-98f0-253c-f8b5-df1e7c1f6315@amazon.com> <8d263a6b-a99f-0f9b-43ba-e8967c386f2b@amazon.com> <2feee395-959b-6d53-369a-c00f8f2fa6c5@amazon.com> <20210727172257.ekvkspdqaeh2etfg@alap3.anarazel.de> <69aad0bf-697a-04e1-df6c-0920ec8fa528@amazon.com> <20210802160133.uugcce5ql4m5mv5m@alap3.anarazel.de> <7094ac62-340f-9b23-3af6-e24fe08c8697@amazon.com> From: Peter Eisentraut Message-ID: <47606911-cf44-5a62-21d5-366d3bc6e445@enterprisedb.com> Date: Thu, 26 Aug 2021 13:35:18 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0) Gecko/20100101 Thunderbird/78.13.0 MIME-Version: 1.0 In-Reply-To: <7094ac62-340f-9b23-3af6-e24fe08c8697@amazon.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I noticed the tests added in this patch set are very slow. Here are some of the timings: ... [13:26:59] t/018_wal_optimize.pl ................ ok 13976 ms [13:27:13] t/019_replslot_limit.pl .............. ok 10976 ms [13:27:24] t/020_archive_status.pl .............. ok 6190 ms [13:27:30] t/021_row_visibility.pl .............. ok 3227 ms [13:27:33] t/022_crash_temp_files.pl ............ ok 2296 ms [13:27:36] t/023_pitr_prepared_xact.pl .......... ok 3601 ms [13:27:39] t/024_archive_recovery.pl ............ ok 3937 ms [13:27:43] t/025_stuck_on_old_timeline.pl ....... ok 4348 ms [13:27:47] t/026_standby_logical_decoding.pl .... ok 117730 ms <<< Is it possible to improve this?