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 1uaF6J-002GdQ-5Q for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Jul 2025 14:51:47 +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 1uaF6G-005STW-EZ for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Jul 2025 14:51:45 +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 1uaF6G-005STO-4x for pgsql-hackers@lists.postgresql.org; Fri, 11 Jul 2025 14:51:44 +0000 Received: from mail-io1-xd2f.google.com ([2607:f8b0:4864:20::d2f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uaF6F-006mFJ-0J for pgsql-hackers@lists.postgresql.org; Fri, 11 Jul 2025 14:51:43 +0000 Received: by mail-io1-xd2f.google.com with SMTP id ca18e2360f4ac-8797652b1f2so108615139f.1 for ; Fri, 11 Jul 2025 07:51:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1752245502; x=1752850302; 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=6skSQN/zO0N+Zck7/NjxojjmaJfqS0/PE8Zjnbx05lQ=; b=cKMt8ql3kygt4MZfrQISbv4ACtVK25MYNSjz890DQesWMqu9sg7R90sURIclo5ZlJ3 oELdgbk2SAKIKawB/rUv9sga6xt5Ra0tIeP91OqtQhpi1g+QR7RbPopHqVuAht8hyrH1 CQQq2Yqq9DHJZjtzh0krbk3wsZKiE/NaNcO3RSzHtmv5UAzzXaXVcS+406aP4z4ki7pN PyDXmkkcmeXJRE7XhgVppAIIoibX65oRmuQrMBL0q4bjQRZUkv8wOmXPaSM4F0kP19qg 5Nm5xg66TnJqKVeU8mzECVE/8SzMnep1scgt6IiLQP7dBnB82sLk5MgndK8Wo9NDanZf 3a+w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1752245502; x=1752850302; 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=6skSQN/zO0N+Zck7/NjxojjmaJfqS0/PE8Zjnbx05lQ=; b=VoKy50yVEj5ihY5FR2hqdjoqpemVv4MHM8IdwzfIYB+I3y64NniiuQ7KaGaQhvRR9d olkh8JP3CCSRPPycre1ncWiQZGH7ToiWgkOqUeYKYKGOoUZhjM4eDYJ8wKD5hhHHlBaX tFU+y6igd0WHQ/m6yZnjvpExLI1boSG1q3Ssfqu8yoUUyVw54TIzJ1DhLVLcs2JFKjv8 Fbula3AWYFa8IHC3kOH9lUUHMQCvv47D3yGPc1gLisZAfJ0DYaurz/chCqnqht566MEy g3fg3skHRSZeZ0MQE1pkuBC9c34/LcpUji/YTuyPTo3Dup7foQmHFjf7z7e1XSlBqZhy wfTg== X-Forwarded-Encrypted: i=1; AJvYcCUkh7jg2oF/JlLn99ABrvZswX/pnX+VNYeLHAOaN39pbykTl/lrnQtJKTO1cdiX9HJfUB//1HBj0qBpbSN0@lists.postgresql.org X-Gm-Message-State: AOJu0Yz39kKXibVTaYfODxvudJCJzFnYZol/zTxxMLxLiY+dx2wG9mrg +QmUI65/1aQurJaK1CDR5GhkX09KnKgSh1VqKhrMdAnAiaZsLLf/1PJE X-Gm-Gg: ASbGncudh5qr4Vr+Fqj9FoUMGozCJrRGbRRhDTSMLUR3tpGTJIBRoxTIsc+FHtNpUsj 9qCHcTPKrMKZNKOhSyaTUX6VhXm7b8wmijsal1aqLKmfLjMbGsG7W6Kunt7FLyrY/VmqK0GSnAN luVu3pNZFKHGJBfeuJSAHPDTd/VdXpq9qj2fmd7Mvwndes7wqfgWLiSdlG+p0Vd0vtK+ncFhc48 xDRUTkHUON1hx7ZFzdjY/0GMr9iMSSIvxPJqPi0CrHby1Cotf7wyV2RSJf1gIoNt5C1o8Up7M7U bgMgkA4bU62cqFvESVAewcvzjOxmuk9IQf5WP9761j9Jw3QHwXR9WwtXSyZP2NKAw5SB/OTZEj8 SlrkQXJbVyO+xBD/w2fBSlSJcns/Lk5/RxtZ41vHOWdwjDQhLUcaY7G30oBB4ZEbu/dhE8CH1cy Hoiixjsdnzx2KxoWuOtuWl9Ag= X-Google-Smtp-Source: AGHT+IFVKHfZ3m92Qpho1MW2EzvT9lkIUmz88Xa0vK9zjK78y/PqgJKVTUAvGD+FIyYKTWjgJkmDlA== X-Received: by 2002:a05:6602:4143:b0:873:47d1:2259 with SMTP id ca18e2360f4ac-87977f893f6mr428737239f.7.1752245502265; Fri, 11 Jul 2025 07:51:42 -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-50556b14167sm856820173.131.2025.07.11.07.51.41 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 11 Jul 2025 07:51:41 -0700 (PDT) Date: Fri, 11 Jul 2025 09:51:40 -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: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Jul 11, 2025 at 07:49:47PM +0530, Nitin Motiani wrote: > Thanks. Looks good to me. Thank you for reviewing. > Also just would like to confirm that the pg_dump_sort change will go in a > different patch. That's already been committed: http://postgr.es/c/fb6c860. -- nathan