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 1ubLyY-00HQ6S-GN for pgsql-hackers@arkaria.postgresql.org; Mon, 14 Jul 2025 16:24:22 +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 1ubLyW-009qtQ-Ia for pgsql-hackers@arkaria.postgresql.org; Mon, 14 Jul 2025 16:24:21 +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 1ubLyW-009qtH-4l for pgsql-hackers@lists.postgresql.org; Mon, 14 Jul 2025 16:24:20 +0000 Received: from mail-io1-xd32.google.com ([2607:f8b0:4864:20::d32]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ubLyU-007GMO-0s for pgsql-hackers@lists.postgresql.org; Mon, 14 Jul 2025 16:24:19 +0000 Received: by mail-io1-xd32.google.com with SMTP id ca18e2360f4ac-86d00726631so123748939f.1 for ; Mon, 14 Jul 2025 09:24:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1752510257; x=1753115057; darn=lists.postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=erTefBWjselJQ1Rk8/7Nh3XmNiFoPFEl0KKGrUGOmRg=; b=W8VvXLiSoiU1MMURytBQgQE3pYqQ9MP2ermdPiBby9NQ0HGDIY5bThELrBstV2bPei ETz1UtmgC3jZLYibNNYop55bSCzNCshRFRBfY/04c312vk27icdIQ5RXfsKgdP4Xja5u 9nLHn5x6GwKAqAgOhoblSCBc4xfLot0t1Bucd6N6D1rM4UXR6tDHhcRgVve667xMtqyE r+oywaglOh6Mz65jD0aKP86TP0eImEE/vheqVGnSfy+n5LYiXKqxNcX9in0pfPbjC9Q/ 7THnu7rvZmK6PBfRIpkqkfiDNwlMYDoKUUTghMhf2IPqKppEoBbhLpfPLCwf+AmbfFLy 1CcQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1752510257; x=1753115057; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=erTefBWjselJQ1Rk8/7Nh3XmNiFoPFEl0KKGrUGOmRg=; b=ihCNdbIzgGPnWpIHRZqWPF7uBkRDsQsXr77I+cl+cr+UYHrZiZHMJDe5Cof+Cmqa/J 6NhDJ2V812GYd1qu9ON0mTPRcGwr0hBXuwV/SXNEILbho5DEM2IJPqxG4RxMtb+CaHLF INIMhZ6KZ82UcKgIN4PoTaoYS9hn1PTiD9Ja4u1a3jfzym6WmwqVHIgeBXdmzyKmLR7F pNVE5F7Pl7l5ixlKIRZxKhb5r8lIsYuG9qutRvLR+JbFFd5Lj2n+aYPeO1JtNz3r5VJg JU+390Ml2hoQjSo04sHWUsj5K0V79HUriZhV/KaULSh6ufDPXBdRecAYT4wW46OS6QIG IIqA== X-Forwarded-Encrypted: i=1; AJvYcCXZJ89Kv1R8fuXiiWk8yix7q7WsRWsSVUliqkul/o9+r2P7KE41zEOvtnxFX5rOA83U0WHVUr6BObf7GHFc@lists.postgresql.org X-Gm-Message-State: AOJu0Ywb4ZbsomxoJa4ySU8TerEK2W8wskgySgCgg7ADJPsRbkFA03pC IiR/tvZHaK/fpoPX8w3/Q79+Fu7xIMAbnamg2A92DU7BWFMTIIly/Ihv+x/ICA== X-Gm-Gg: ASbGncufpnOGYIhjxDvkjODQWsWGH/Vv9h4jX8brGSaiiEhcFEXmGjb40Bnb02/6pg9 uS/D6rdqO8EAdSWxpd0Fr1HNYMWMJ90KNYUWQe+61ItYnWQpKwXo9GdP5cjfSGt31f97SNe2xrm vA/om4qm9rsb5In6o/IMesS22L49oVFJbTqRNW2tFhX5Tgv5X/zLkUO5lVXCtR7jqDk0tdOiK76 CIK/PsAYEB0ovne8pbxD3COVl3I86h2DURvqJFUg/L1kvbBPwz6z6vH35/6aF58ucGxgZqhC3b0 LSCibEqwZEXxCo0LgmXEIGA4POMPJXX9pv4tY4iiZ0WwjL/CaLKMdzb000GbiLGy/u4r0J9ilt+ nhuypZCiyOHtJdn3rtj4l6TT6ps1xuQXsEzQrNnA+hhLyltFmR7x8Ey0JqmiIbYGfF3LvmKZ/yh Hjc/OCb7qs7BTW X-Google-Smtp-Source: AGHT+IH9g/IgIE1xQWCQ2qdMC739s6InTxXJWb2ipvvWyotBqKVxdZr/8mxUGu9PnHoVbzRGPjyKBA== X-Received: by 2002:a05:6602:3941:b0:86d:9ec7:267e with SMTP id ca18e2360f4ac-879787e9615mr1649378039f.4.1752510257235; Mon, 14 Jul 2025 09:24:17 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-50556538b13sm2096939173.14.2025.07.14.09.24.15 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 14 Jul 2025 09:24:16 -0700 (PDT) Date: Mon, 14 Jul 2025 11:24:14 -0500 From: Nathan Bossart To: Nitin Motiani Cc: Hannu Krosing , Tom Lane , PostgreSQL Hackers Subject: Re: Horribly slow pg_upgrade performance with many Large Objects Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="9qD3eLYy6j4n6wEu" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --9qD3eLYy6j4n6wEu Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Here is what I have staged for commit, which (barring feedback or objections) I am planning to do towards the end of the week. -- nathan --9qD3eLYy6j4n6wEu Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename=v4-0001-pg_upgrade-Use-COPY-for-large-object-metadata.patch