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 1udrfU-001aVO-Kg for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Jul 2025 14:39:05 +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 1udrfT-001OoR-PO for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Jul 2025 14:39:04 +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 1udrfT-001OoJ-GT for pgsql-hackers@lists.postgresql.org; Mon, 21 Jul 2025 14:39:03 +0000 Received: from mail-io1-xd34.google.com ([2607:f8b0:4864:20::d34]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1udrfQ-0003Su-1n for pgsql-hackers@lists.postgresql.org; Mon, 21 Jul 2025 14:39:03 +0000 Received: by mail-io1-xd34.google.com with SMTP id ca18e2360f4ac-879c7464843so255586039f.2 for ; Mon, 21 Jul 2025 07:39:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1753108740; x=1753713540; 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=h4FVnvvpvCcjLKATUj4A2JjXqmiTZ0Px4L859gqZ264=; b=UGcsOoZhlq8EGYTSsnOiczRQVgYtVLzKNTJEEI57kcc85BY7LYzGAGu2+H283jjps9 x7yGIVrnLngx8TmBDJXkb1rY9qDC3W+UyTeDzTfBliRU35b/LuiXeAEsw0rm+YUGILx/ zfToy2YUzIg4Ut6DAaBHriLoybdmA/Mb0rfpsvHgtv3uWYas0Br78S6F0JDaucmOQyG5 xP+GKB6ZmPqsp8PTXD5/0JhnMw/+fESTeY/zrZUzQyT2r0+a6PvQ5moV/pjkJjTKRbar AwsEL2Mm246ULo+/UWjbRV+YwmFpxCyt3qACqNOJ4Mat58uEbNk+e0TfY4uFejew3TaR qO7A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1753108740; x=1753713540; 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=h4FVnvvpvCcjLKATUj4A2JjXqmiTZ0Px4L859gqZ264=; b=AbrvzpihL14YRmEhKvS6PzYqi/pC9jHrgHEm32OIQi/D39mp+IZlC9buT8C5cnp2xZ atSp17WABSw5DrbBLPkHgOPff2STk83JXyDjexCkOlXIa7FL+F7KLPMbRGRuiDtVllKA Eb2Y1SXpU9fS/msxvz3wFB5mgFfFTVJDNDToVxCwlk2Gfyyacu191sAJ0SaL027H87lF +n/cTJiInSgFhu/GFgIjD9QR9ocUgMlV3uO13rx04ufTQZUrtUcZLSde7Zxo+EZiIutA jmYjix1+KLN3vwPU0SpCCbeA3Ap7pNeyIGjprabxHVbufQzx+Nf5Y+3MqoawFH5hphxO ya8Q== X-Forwarded-Encrypted: i=1; AJvYcCXEDr+LHfqQMFl7MSlhcZJzYW4XLnxZtFXqPfk6ZzRMjghitUMn7OUMUfmpZVq7eC9vGAdgHoticc04L53f@lists.postgresql.org X-Gm-Message-State: AOJu0YzGy0i4QmKOeEUpUYgXbbID3mVZUDvJN0Aihn7PeycHW30ir9Hn hUqYmceWk/n/UZ+XN8rtOYdhuZvCauceyW4Po9Ie1eQQpKX6gnV+ul9S X-Gm-Gg: ASbGncuGuqb0ObUTGKtDAFkYxxi4Z4qOT2COF2OJ5iO1+yxEsxATH/XITy/vJ+5BrUL D2qg/ABdwm1tcBl0v5oqsATdBpV7yiut8m5g2QgmCbazuUYJqNUboJrtZok4MrHA53eHHgeP119 HcvzLakBSJ+aicvvwwLJLbw32+YQ2gF7IxCdUFsspeTrX5rcyvxmrOv3XnqsY/f8yCIDeES1HaW 4FWOcc4e1jLuxwMkYRdtdpML0vZ64JafkFb5ikxEdcj9TpDQwfCvjGIufoyoaH42gMaRfh1lYvo LPEDQcWaQ43JupRxyvDWYH0v91h4eqZzIksKuFxOo4taSM5Onht8fld7uRtlkmYX3SREhAPFYe9 mV3KPUnThIh7XWBTZMx9RWcyIsCY9yeMmysPUowVzPxkfm0usx/xrCMECIP6tzUCB/pJHJmjN31 UA0H1YquwdCX+6 X-Google-Smtp-Source: AGHT+IH4pYVXZvYvW2dIFdNcju2+9q0vthlcZ8P1M0mNVXnAUCQLkOhx+FRsCfP7c7+ezuhFsofJdw== X-Received: by 2002:a05:6602:a01c:b0:87c:4829:8369 with SMTP id ca18e2360f4ac-87c482997d2mr445476939f.14.1753108739660; Mon, 21 Jul 2025 07:38:59 -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-5084c7bc643sm1871450173.27.2025.07.21.07.38.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 21 Jul 2025 07:38:59 -0700 (PDT) Date: Mon, 21 Jul 2025 09:38:57 -0500 From: Nathan Bossart To: Hannu Krosing Cc: Tom Lane , Nitin Motiani , PostgreSQL Hackers Subject: Re: Horribly slow pg_upgrade performance with many Large Objects Message-ID: References: <700576.1752514083@sss.pgh.pa.us> 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 Mon, Jul 21, 2025 at 02:03:45AM +0200, Hannu Krosing wrote: > Do you think the current patch could be backported to at least some > latest versions ? I think that's pretty unlikely. It'd be a pretty big departure from our versioning policy. In the past, we have back-patched "critical" performance fixes, but that involved changes that had already been in released versions for years. -- nathan