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 1u20wt-00BdS1-DP for pgsql-hackers@arkaria.postgresql.org; Tue, 08 Apr 2025 04:52:35 +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 1u20wr-005mjw-RY for pgsql-hackers@arkaria.postgresql.org; Tue, 08 Apr 2025 04:52:34 +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.94.2) (envelope-from ) id 1u20wr-005mjg-9k for pgsql-hackers@lists.postgresql.org; Tue, 08 Apr 2025 04:52:33 +0000 Received: from fout-a3-smtp.messagingengine.com ([103.168.172.146]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u20wp-0043p5-10 for pgsql-hackers@lists.postgresql.org; Tue, 08 Apr 2025 04:52:33 +0000 Received: from phl-compute-11.internal (phl-compute-11.phl.internal [10.202.2.51]) by mailfout.phl.internal (Postfix) with ESMTP id 751E4138013C; Tue, 8 Apr 2025 00:52:29 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-11.internal (MEProxy); Tue, 08 Apr 2025 00:52:29 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1744087949; x=1744174349; bh=4Xt8Kkleis WCPqUjLhjerIy8uYm1IMMDbBuWJMt4QC8=; b=M23IzGk63f8rXzUOsKKE15Lyp0 HDSjdt0pOZ4kupPk6lB6xKAuc5tcWk4HLoEDWBVgYsxOAaWF+2/xaMau7gEkPEmi Vw+qzIeqidGuV45MDJwnGkyWU1+ImVW8BboIczHD6iGleDrFkWGvLgoFVVSKHYwo R0sRck8Jvcl38L+YEEitg4fj2U7YuEGLYIfm1el/Ud+1IgkKAJAQCR9kb86MfM36 LKMpelAjP00lNQsc0T8DQdbJfwabWLB778lf5EleMXzoC9nAd4Zb7OQIrXIQ40K7 WZMwU4RvXK3+ogTLmaQvL5VBKyLUZLaq9vWOc+Fi9GHNMpLCyv8bKLjYcXrw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc: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:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1744087949; x=1744174349; bh=4Xt8KkleisWCPqUjLhjerIy8uYm1IMMDbBu WJMt4QC8=; b=Y8mIGJ0XrOTTqpMqQbZqdCvBO40d3cKYRnojMVS35rTp5TAOeEu V5qvc4hgk/zety7xeF2MMBJWR1ULsX7FvKEjjFR0OjYNT2OnhPsJJmY+n/2e/xFg aolSUHx0Rq5YxjCMMbDpdPcAkbb79t+6qHidf6FODIJWPBo6XevMa6J2YWG8J0EY C+crrZ1rQDOTfmCcgRioM53ivB9uVVFLMtn2roTcW8yFdfOLrTx/1ZQs1OvcKrer pTzCxzsWuY+GxHVHUjar2gwMqsjlw4LPv3Z1bt9pcGS0QUWXtOcap2SkbQVDeaIl c67E9e8c6FcBZCjRIfxgXyKnP689XuFNFmA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddvtddvudejucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnegfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefu kfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivg hruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhep teelieefudffhffhtdetleeggeegfffhkeeuveetiefgudduvedutefggeeivdejnecuve hluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggv lhesphgrqhhuihgvrhdrgiihiidpnhgspghrtghpthhtohepfedpmhhouggvpehsmhhtph houhhtpdhrtghpthhtohepthhglhesshhsshdrphhghhdrphgrrdhushdprhgtphhtthho pehhrghnnhhukhesghhoohhglhgvrdgtohhmpdhrtghpthhtohepphhgshhqlhdqhhgrtg hkvghrsheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 8 Apr 2025 00:52:27 -0400 (EDT) Date: Tue, 8 Apr 2025 13:52:12 +0900 From: Michael Paquier To: Tom Lane Cc: Hannu Krosing , PostgreSQL Hackers Subject: Re: Horribly slow pg_upgrade performance with many Large Objects Message-ID: References: <3681760.1744061132@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="q8yx12M1CpTROgzd" Content-Disposition: inline In-Reply-To: <3681760.1744061132@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --q8yx12M1CpTROgzd Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Mon, Apr 07, 2025 at 05:25:32PM -0400, Tom Lane wrote: > What version are you testing? We did some work in that area in the > v17 cycle (a45c78e32). I am puzzled by the target version used here, as well. If there is more that can be improved, v19 would be the version to consider for future improvements at this stage. -- Michael --q8yx12M1CpTROgzd Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmf0q3wACgkQnvQgOdby QH0GcA/+PerlMdrRk+2p9r5O4kDLioxuTmjH6rEBzZvOAm1hItHGQW8wRIQ8KeXq xLpygTn/Hl6ej04UI2sgg3BPYVfNg18dqdiL4RFjKdb8hLJj/QT/IuswDkp3iFDd wFkN4HvgqkjBjKlB7LMcx1KYhIqx+ZMfKPzIKSU+PWa4aa6q8z+Dsg4u62k7PyFm ewCbCfGgjJeF7a2dEwjvYVsTDlRgFg5n/BKUDV6d7GoBRJD+4lwzuNLYFunNrtH+ aYSkye2rlfCOeEkXLu435BjkGx1jNJ6N4+qccOueGD3tvLLQaeCR9O/zBrNttHbw HW7ssqEA2lQ73AHeqjuyJWB1ME99y/po22bhNoy+pB5/8h7SwNDha8exs55UTcoH J0H0ArUjiFhP1YTPw3DUSOoCnUkSvKHYGA35OxfSgyTD8l+h43YT5DM0cQsrD8jE 2L2+Q58RZj9PTazeXlxclOh8C9rjotaGFIHv03aDKKBhT+7m6AoWi+7EoVFQyuOS iZoHNI545766pszGshYogLD3vZ8Ec3Z7vFyJiMNso9Xx6I1XS8Fwo0hCIshI4n9t 3/Wiq09vjxlBtwgWqea+XpH/IDFGKyZ+hdTgnQdy6AJuS8vzXY6nlhBnhqlPuDC1 G2TFp02E9+Cu6w8fw7NFOLsZLh1zRuB+esNoQ2shJAY4ZWYjdL8= =WoXJ -----END PGP SIGNATURE----- --q8yx12M1CpTROgzd--