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 1sqJ52-008baE-Kj for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Sep 2024 21:16:21 +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 1sqJ51-0000Q7-RO for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Sep 2024 21:16:19 +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 1sqJ51-0000Px-HW for pgsql-hackers@lists.postgresql.org; Mon, 16 Sep 2024 21:16:19 +0000 Received: from mail-il1-x133.google.com ([2607:f8b0:4864:20::133]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sqJ4y-001Xfx-1f for pgsql-hackers@postgresql.org; Mon, 16 Sep 2024 21:16:18 +0000 Received: by mail-il1-x133.google.com with SMTP id e9e14a558f8ab-3a056727fdfso14960255ab.3 for ; Mon, 16 Sep 2024 14:16:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726521375; x=1727126175; darn=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=uQDbDiytv0LVjvPNOR50zesD+wHql+AS3WkJ23swHIg=; b=JvIZXpoGk2Bm1TWMEaR6kZDJyUqr49NYA9fim5mudgFnGlD643uv33WWdvTghjlxpm cdeyaO0RscJuvKsbKKd0KMnies7Sv5SmGa/L+RHFil5N4Sm0aESsRny9V/44oYFW6p8W WhdwAMfEQxzlxh4+k+DMeZA1C00LD+/igcw+wqDtaOyGZjbhGD7e2JfAbo/Xml4l6US5 g5UWqy/khacH5Z1C5NOgbvjfS6AhOd/hbZHJ1PIujUYUuYWQl2wGeaPUv8+lJKp7TJ2O +zim9t3wOGMSNXQyYlu7SAL0rRGYiMAAfBdxKZ3WQZSzbPhr8MVKuODE7bczcJo+zZQP T9jw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726521375; x=1727126175; 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=uQDbDiytv0LVjvPNOR50zesD+wHql+AS3WkJ23swHIg=; b=q9a8DSfIHV1El8Ldp3jsZfBVHOX2IGmkkJ4H5sp9hEBLrVLrXGQTj9HyKK5Ch8abOH 8RU4oYd3Wc/Y+9SO+Ztdpo8917tiyWtj2wZCwBmr2T5wI8pCUtINlE6uLEoF+m3EBnne ZKVaGAofYVwnFJIqteihRz//Aw2oznH1dsUttJvPKLaY39pJQleLHQCl35+SrV5pfvQE 8qLIZWP4XBN+PFvNX6ycAiE7lsUhVooPwNl9y8yzBse+3/Q5hB91QMW1wariP4cwYF7e g3jog3WUeK3j/89kaAWOYREeebrJ+vwNV/Rz1isdaCGNUgkHM+Sizbng3BGjAU2oHg8b ztcw== X-Forwarded-Encrypted: i=1; AJvYcCXtdR0Rp5sbzd6hX6Eumi0w46GbtX+dZezSyu1qXeOyfmLF06xJng1nyJrm8VrkcfxX6HHIyRrl4ltu1otI@postgresql.org X-Gm-Message-State: AOJu0Yw+sO68e5uz5Rf08+fEFuJvBOFEVZfoAWut87USl8Mk+eJI8EMV 6zNXbWAYoRy5fFhLayVq0DUqgE5hqZnGAaEQQrerl1R51TfXlJRz X-Google-Smtp-Source: AGHT+IG53o8byWzCPZw0s3kpgoGGhLQPDNcWj2mkCX2vb7TN9EyovKmDIj+Rm6+gyolXCoHtYAdPgQ== X-Received: by 2002:a05:6e02:1d12:b0:3a0:8d2f:2914 with SMTP id e9e14a558f8ab-3a08d2f2c09mr102385365ab.23.1726521375344; Mon, 16 Sep 2024 14:16:15 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-3a092e8d268sm18721275ab.71.2024.09.16.14.16.14 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 16 Sep 2024 14:16:14 -0700 (PDT) Date: Mon, 16 Sep 2024 16:16:12 -0500 From: Nathan Bossart To: Daniel Gustafsson Cc: Ilya Gladyshev , Corey Huinker , Robert Haas , Jeff Davis , PostgreSQL Hackers Subject: Re: optimizing pg_upgrade's once-in-each-database steps Message-ID: References: <3A3553B1-123D-4F11-9426-277F2E920AD7@gmail.com> <0fe740dd-cd23-45a6-b116-c777349acbf1@gmail.com> <3A4280AB-D57E-4F9E-B1DB-63C80C7E891F@yesql.se> <99090248-9EE7-4DA3-AC78-4F46337BD183@yesql.se> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <99090248-9EE7-4DA3-AC78-4F46337BD183@yesql.se> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Sep 09, 2024 at 11:20:28PM +0200, Daniel Gustafsson wrote: >> On 9 Sep 2024, at 21:17, Nathan Bossart wrote: >> >> On Thu, Sep 05, 2024 at 01:32:34PM +0200, Daniel Gustafsson wrote: >>> I've read and tested through the latest version of this patchset and I think >>> it's ready to go in. >> >> Thanks for reviewing. I'm aiming to commit it later this week. > > +1. Looking forward to seeing what all the pg_dump/pg_upgrade changes amount > to in speed improvement when combined. Committed. -- nathan