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.94.2) (envelope-from ) id 1r16EL-009J2v-84 for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Nov 2023 14:42:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r16EJ-00FB0r-Nb for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Nov 2023 14:41:59 +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.94.2) (envelope-from ) id 1r16EJ-00FB0j-EO for pgsql-hackers@lists.postgresql.org; Thu, 09 Nov 2023 14:41:59 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r16EH-004kmG-1P for pgsql-hackers@lists.postgresql.org; Thu, 09 Nov 2023 14:41:58 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailout.west.internal (Postfix) with ESMTP id 76D043200B36; Thu, 9 Nov 2023 09:41:55 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute6.internal (MEProxy); Thu, 09 Nov 2023 09:41:55 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org; h=cc:cc:content-transfer-encoding:content-type:content-type :date:date:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:sender:subject:subject:to:to; s=fm2; t=1699540914; x=1699627314; bh=9/NFLYW+VMhTe7gonzhN+3t/r mMjLbPlGYH2OQVOs2I=; b=EnfNek2N9dMtUOVM+/zfyOYZaVZQKV+Bld2NA6zFd 7BE1AG6qfQq5pj9yTQEZfl6OvFA8a/8sBwEES3WBc1R6KM8oydMpGJd9yxppOCis TlsHjWz2DIn04NiIknQRdiK/mDhLhyukwwKPsgFPEgP9LpHeTMp3r3pwZqPGBvee myysqPvLQ4z+VUCFHDBn48cwjGCrcib6WTPQr4zJfqPvMFdCQSmWzM3nnwQUaJbG lXlN/muANSz6oN03UgMQI863/Tdgmj9l6/RTD199PEXdkzs/7zCjJ9bJipJ/Rwao RJPfLYCFM9WWuXDsyX0qR87V1snA9Jvkxj50Ng29FaoHA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1699540914; x=1699627314; bh=9/NFLYW+VMhTe7gonzhN+3t/rmMjLbPlGYH 2OQVOs2I=; b=uSPGRb8dYj3JodI9IzYdrHGfvDoyvJJeP/7ym/lBxSW1mX1IPym 6LvCoFPjZhqevez7+/qKcxCvu1qeYbTvhvKXo2szRTHGaWr+Wme9amAZi775VDHG Xn9pnYuMlU4sZBznCRgIYhsfD7wIlqF1NH1vbsIWnEPP4xsvz0w2jqyxeUBcwvm5 /0RX4vTUQQzScd7Qh65N/cDj+lL+qx1HLHJ1kMEOikS7iVkBPQyRiWyQP45zOE4l f51u5MfBOsIWN2rBUo+8XiR08ePwiZ4yqN7Q2ygVYX5YP4xkh1pSHSaWsQBGKzRK 9OngwXGS2qrtBeMmfHl3Li8I2xirh9G9YEw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedruddvuddgieeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrsegvihhsvghnthhrrghuthdrohhrgh eqnecuggftrfgrthhtvghrnhepgfejtdfhkeeftdeugfeileehteeljeeghfeuledthfeu tedvffdukeefjefhgeehnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrg hilhhfrhhomhepphgvthgvrhesvghishgvnhhtrhgruhhtrdhorhhg X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 9 Nov 2023 09:41:53 -0500 (EST) Message-ID: <96e3b739-d63d-4d35-90a3-7869465b7167@eisentraut.org> Date: Thu, 9 Nov 2023 15:41:53 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: speed up a logical replica setup Content-Language: en-US To: Michael Paquier Cc: Euler Taveira , pgsql-hackers@lists.postgresql.org, Amit Kapila , Andres Freund References: <5ac50071-f2ed-4ace-a8fd-b892cffd33eb@www.fastmail.com> <4710d895-689a-4ae6-b8e3-344286dbf970@app.fastmail.com> From: Peter Eisentraut In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 08.11.23 00:12, Michael Paquier wrote: > - Should the subdirectory pg_basebackup be renamed into something more > generic at this point? All these things are frontend tools that deal > in some way with the replication protocol to do their work. Say > a replication_tools? Seems like unnecessary churn. Nobody has complained about any of the other tools in there. > - And if it would be better to refactor some of the code generic to > all these streaming tools to fe_utils. What makes streamutil.h a bit > less pluggable are all its extern variables to control the connection, > but perhaps that can be an advantage, as well, in some cases. Does anyone outside of pg_basebackup + existing friends + new friend need that? Seems like extra complications.