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 1sP5ew-002q1i-5U for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Jul 2024 19:28:54 +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 1sP5et-00BakB-Md for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Jul 2024 19:28:52 +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 1sP5et-00Bak2-D6 for pgsql-hackers@lists.postgresql.org; Wed, 03 Jul 2024 19:28:52 +0000 Received: from mail-il1-x131.google.com ([2607:f8b0:4864:20::131]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sP5es-000Gci-2x for pgsql-hackers@postgresql.org; Wed, 03 Jul 2024 19:28:51 +0000 Received: by mail-il1-x131.google.com with SMTP id e9e14a558f8ab-38257b4283dso3977665ab.2 for ; Wed, 03 Jul 2024 12:28:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1720034927; x=1720639727; 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=39PIA72d8ZlGWFJY+vRitN4j7KmveightchgWhVIIwM=; b=XqSULLHjQhLN/Ku2ietqpEiNKI0AIMmRCgDfJrxm/e8kAr0cd1jThwit+eEWxghb8T uuOf20br/wWyFWh7y6XD+/Dw09IwB2+Ig1pJ1j0xqDHYhN9cJM/FDtNGduINq/zaYKJh 7X6V81WXzTqyCEthxw/h2I4EMMmio7uaNCJV+QajgTyemEhkA9LqjjDgV3OuPaHarlWY OvxJ45s/bwW4ZR5uCgZ9flCKV4b51O3dUbI+ymfvY9LSM4pA0khrl/FuzDG04Fo+Seu8 Y7Z3cJLoFYVcfeIxMtYJO0drIIZgSRGIzmhqGW2Fs2csQGplucgNE2JM2AZLvf7RfbxJ oIzw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1720034927; x=1720639727; 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=39PIA72d8ZlGWFJY+vRitN4j7KmveightchgWhVIIwM=; b=pR3uOFmFCaddDVM6jEpPrAHXAcYsiJX12LbfJrwpnAzRSph71jgEJGesjVPpahUKf3 rY7b12u5lykBzoV9cvtW/4A8XCg0d1lA/9LeIrrpyNe1MRM4NBGN6Si8AB12ItUGT7PJ 7odDmMmJo4/5GoOGDvMJsL54S240D3UoZSN3XP/9TVlq1Z5H6BlRKeCW+grjluSIUpXn bWAllJw4wn+Ted5kXl0gpWnMKnjShkzxvtK5GkY7h4lSIcJmakwHXG6akALa4XZ/9Y2W 1EeHYsnNXsC6jzovsuc/K/Z7unGHsIsMFus0oct4A93VroCoXnO5AHuB+HzuW2Q+l3iW ZSfw== X-Gm-Message-State: AOJu0YySWMSg4e8uGu5xUTF5cLf8w7bptTPuZQXPZczMFohT9W8i3DbK TF/i113pqPt8fX3ltWAKygxVTOePkcD6o1YBJU2StUoH+tJv/7WczEB2at9h X-Google-Smtp-Source: AGHT+IGTR7r8H5HwR27n1SZKazCx7ipvlPBXckUfdM5H21ExQMVO/vX0sWvvU7A11VOwss1b4FX3cQ== X-Received: by 2002:a5e:c70d:0:b0:7f6:1cb2:8027 with SMTP id ca18e2360f4ac-7f62ee7a0bemr1455227439f.17.1720034926638; Wed, 03 Jul 2024 12:28:46 -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-4bb73fa1248sm3525917173.102.2024.07.03.12.28.46 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 03 Jul 2024 12:28:46 -0700 (PDT) Date: Wed, 3 Jul 2024 14:28:44 -0500 From: Nathan Bossart To: Daniel Gustafsson Cc: PostgreSQL Hackers Subject: Re: improve performance of pg_dump --binary-upgrade Message-ID: References: <20240418041712.GA3441570@nathanxps13> <20240418152301.GB3501884@nathanxps13> <20240418202813.GA3669511@nathanxps13> <93129B02-33E0-4591-96B4-0B9C2183C7B4@yesql.se> <20240418211924.GA3828609@nathanxps13> <20240422190103.GA367217@nathanxps13> <20240517152244.GA1911062@nathanxps13> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20240517152244.GA1911062@nathanxps13> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Committed. -- nathan