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 1qc8J0-00DwjE-KO for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Sep 2023 17:51:38 +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 1qc8Iz-00GESq-I1 for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Sep 2023 17:51:37 +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 1qc8Iz-00GESd-7X for pgsql-hackers@lists.postgresql.org; Fri, 01 Sep 2023 17:51:36 +0000 Received: from mail-oa1-x2c.google.com ([2001:4860:4864:20::2c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qc8Iv-002NtF-Na for pgsql-hackers@lists.postgresql.org; Fri, 01 Sep 2023 17:51:36 +0000 Received: by mail-oa1-x2c.google.com with SMTP id 586e51a60fabf-1c8c44053e8so130577fac.1 for ; Fri, 01 Sep 2023 10:51:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1693590692; x=1694195492; 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=IZwTq92ZZbQxDE/qdOcSX7GFBur21ZD1aTkcPblYBTs=; b=h4Mr+tiAv4LlQ98FsYA2TDi3kpT73TL7B2tVRclQXtpZftf+/1vzGfC6YV2aOulX5I ECR6qsIK09MKZ+zdQEIdLzKerDQyYnJuZ+gbYzR8R/Y4UbfkL/32i69RuMVPYkYENafg sVZpy5rF2oMMHue4jRy2tyCliGy33v4eNtUW0iclis+fb+FNEHHpOcMKIp9uQeOGDSbo HWNBJYCQeDpCdUXA6Kvca+Hqwd+BFrzehuGgluVsOwBTRo2dSps3vjs9hOKyQxJFFQqA tw4BO86qsWEfi014O7SeWgq6NBOTtD/pLOaLxyGJPNkvjpbnytODLbEnAs+y4MOGaBgi AwBA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1693590692; x=1694195492; 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=IZwTq92ZZbQxDE/qdOcSX7GFBur21ZD1aTkcPblYBTs=; b=NA3QTSmsFOnXIbIHa2NayCe2dT+yVEh55HHDI7/OhnB+euncjj+BF5k33sDmvpMF1h GIUg9rc36fTeb1IvTa3kttvZlMljOgHq30DcD2HzekSOheFt16+Fdzsdm+AUdiEBYoOp Vv18emVCqOPEyxnEOurF6zbaNwPdd56Vjwzhn3vfaZGpGDGzeABaWEUwjSRzf/gQP0o6 8PWjaMmIQekV1N5kDXzc/JmilkV00BZQ23EB5deUjLmg08uBvWmKXQkIy+kLnGuIda2X HFKa7UvUHUFh25QeyH5Od5IJooDHBuqR1ts7UU9AmhLkZ9PRfKlWfwz7IQxMm6Iy7KLr DL2A== X-Gm-Message-State: AOJu0YxxAmzbKo/BrZQLPS+0uPXnvV1xCyQMLhj56Wta6rQtBMaTzuvm 1yl/lNfUfv/uLeKSwPrG43A= X-Google-Smtp-Source: AGHT+IFPATru3jvnWiUd9tF/1Gz+2+L03NAefuGDEqT+fchE3/uu3smVCdfAjAeKv+8m2KGzl3OfmA== X-Received: by 2002:a05:6870:786:b0:1bb:7f1d:10f5 with SMTP id en6-20020a056870078600b001bb7f1d10f5mr3688884oab.20.1693590691974; Fri, 01 Sep 2023 10:51:31 -0700 (PDT) Received: from nathanxps13 ([2600:1700:48f8:340f:6862:ed15:920:90f8]) by smtp.gmail.com with ESMTPSA id a7-20020a056870b14700b001cce851c7basm2403580oal.11.2023.09.01.10.51.31 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 01 Sep 2023 10:51:31 -0700 (PDT) Date: Fri, 1 Sep 2023 10:51:29 -0700 From: Nathan Bossart To: Tom Lane Cc: Alvaro Herrera , Andrew Dunstan , pgsql-hackers@lists.postgresql.org Subject: Re: Inefficiency in parallel pg_restore with many tables Message-ID: <20230901175129.GA3180181@nathanxps13> References: <20230718160511.loirkf5fwjm5ut73@alvherre.pgsql> <20230718160713.GA1139177@nathanxps13> <20230720190644.GA1724613@nathanxps13> <20230722231941.GA2020225@nathanxps13> <1225141.1690069670@sss.pgh.pa.us> <20230723055703.GA2421212@nathanxps13> <20230724190015.GA2528613@nathanxps13> <20230725185336.GA2911441@nathanxps13> <20230901170546.GC3178187@nathanxps13> <563498.1693590101@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <563498.1693590101@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Sep 01, 2023 at 01:41:41PM -0400, Tom Lane wrote: > I've not actually looked at any of these patchsets after the first one. > I have added myself as a reviewer and will hopefully get to it within > a week or so. Thanks! -- Nathan Bossart Amazon Web Services: https://aws.amazon.com