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 1u2Cx3-00EhBW-RH for pgsql-hackers@arkaria.postgresql.org; Tue, 08 Apr 2025 17:41:33 +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 1u2Cx1-00DCKP-Ft for pgsql-hackers@arkaria.postgresql.org; Tue, 08 Apr 2025 17:41:31 +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 1u2Cx1-00DCKH-60 for pgsql-hackers@lists.postgresql.org; Tue, 08 Apr 2025 17:41:31 +0000 Received: from mail-yw1-x112c.google.com ([2607:f8b0:4864:20::112c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u2Cwz-003iof-2O for pgsql-hackers@lists.postgresql.org; Tue, 08 Apr 2025 17:41:30 +0000 Received: by mail-yw1-x112c.google.com with SMTP id 00721157ae682-6ef9b8b4f13so54836207b3.2 for ; Tue, 08 Apr 2025 10:41:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744134089; x=1744738889; 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=kmw/X1Agkv9Zq1lZHAv+C5vqx96dpCWfHoPsL3TCW/o=; b=bYPAyqKDkgKTYXO8P/+FWu+tR2u+jwnsSECfPSTa6Ab73WU1GXJrjgF3nPkenyg8rT JHXWrvhTL2DSvhu2P2EMC046Uf5JmIrBgItt9BDWc8+mJJh7PTzqU0RvnE6XP/eQN2pw ZAFT9u/YtoKn0em/e61JNJ3EARWVvztrC/3eYlJnVxEbMwnpm8qeBwDQ1C9yryLiMF+w IWr/jWGqFQJ2F8tSE+3ckQX8G+Rv2ZfrUYbBrd+qO/YyZ2bi+R9KSVse5UZ1gFK0kCKU F8d7oMiKQF26MACgAW3kAvr01RB3aj4/NybaQLty0mk5ru8m1F4U2chXBjGV1gUqFL1C 3MeQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744134089; x=1744738889; 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=kmw/X1Agkv9Zq1lZHAv+C5vqx96dpCWfHoPsL3TCW/o=; b=PA9tzyrqHG4GsbYYuqKTVlRmVGJDENA0gghPBcd/5goZ93zxsnXGLQJfjydobC1uyF COirtGozG+e996kDp7dQZSf+ou214LRuvHIITJnwP9I4wBSjhPaR/EB8ekbWxHHOP3/F pAeL2Phio7dkn6XmJ9++cj30pckiYr2bve8vksaismLIVNFZMR98r3+j/G92xDl/SU/U jkVRHU6BQctMGpaqbE4rfhWzWofGrZjrtuTn30EDzoLbRuajMeeeETvZiDJTl693Kf1Q LkYaIceSHnCtxKSbsX/Xdixq69MPGfrZl35dg/lO8anrtJfiVxthh0PAYgHX16qVFcZc eltw== X-Forwarded-Encrypted: i=1; AJvYcCXfBbNIVs5IcvxXVQNHsrrkQ4+QoC0Ij2owOPDENDEYIS15KORMrBP7AM+hmgjUkQZgiZuB9A6XJjC+RfPZ@lists.postgresql.org X-Gm-Message-State: AOJu0Yyl1Mrihr9CJdO9EJY189zda+w1YyfHGayZAxe60i+YNZx5BEGi SpgJTQ1xtuz1+yWS4eBSxu+1be9ECo1tl1bC4Fz4L4gGpPYklW2+ X-Gm-Gg: ASbGnctm6UTh7h7YXDfSjX0iJFXPHm/BCJlpmslQBAzfcFDt8kUC8phiCmTd6efgqNm a4w4/7oRstvQYl2WApW2goE4bEVfZwfrDZBq2IaecEA6udHArE5vSjLCyIfVoig8MhA+JcPKGU/ fb7YMPureo8+0SFgC73GNOng/Mk/99jgEHABnHcf5zr1WCcdNPvtdTUoRiDK6bnB0vj71JNQqWF W6ztiQDf8CEH2L628i8Vsa+TUDl6BUZxzmIwYT+qdpdTv34tEeCWI879tncNoA+I2U1cB4FgGS+ n5zn+Kr218PN7diPNJGdMqzTtLktrZSyoGNhiKjWBav2W0oCgaKMNhMyEu/ife3jW23fR1r/giS N0gf7stGerFariLs+CrvqErE5PsJV19WKP+NLEtg4roBDtw== X-Google-Smtp-Source: AGHT+IFwIror4iSlSQZBhUR2vazKK37yPCsCfLJLwQhMwfWJq9Vt07ye8xAR5Tf41s2/gW1f2mLz2A== X-Received: by 2002:a05:690c:7089:b0:6ff:28b2:50bd with SMTP id 00721157ae682-705387d06a0mr2435627b3.2.1744134088903; Tue, 08 Apr 2025 10:41:28 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 00721157ae682-703d1e80aeasm31959427b3.57.2025.04.08.10.41.28 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 08 Apr 2025 10:41:28 -0700 (PDT) Date: Tue, 8 Apr 2025 12:41:26 -0500 From: Nathan Bossart To: Tom Lane Cc: Hannu Krosing , PostgreSQL Hackers Subject: Re: Horribly slow pg_upgrade performance with many Large Objects Message-ID: References: <4044567.1744128814@sss.pgh.pa.us> <4047312.1744130263@sss.pgh.pa.us> <4050387.1744132029@sss.pgh.pa.us> <4054389.1744133818@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4054389.1744133818@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Apr 08, 2025 at 01:36:58PM -0400, Tom Lane wrote: > Hmm ... one annoying thing for this project is that AFAICS pg_upgrade > does *not* preserve database OIDs, which is problematic for using > COPY to load pg_shdepend rows. I think it does; see commit aa01051. -- nathan