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 1qiPY5-006M8p-S4 for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Sep 2023 01:29:09 +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 1qiPY3-005J8f-Qb for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Sep 2023 01:29:07 +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 1qiPY3-005J8O-Fv for pgsql-hackers@lists.postgresql.org; Tue, 19 Sep 2023 01:29:07 +0000 Received: from mail-oo1-xc2d.google.com ([2607:f8b0:4864:20::c2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qiPY0-0060Ul-8q for pgsql-hackers@lists.postgresql.org; Tue, 19 Sep 2023 01:29:06 +0000 Received: by mail-oo1-xc2d.google.com with SMTP id 006d021491bc7-571194584e2so3190151eaf.3 for ; Mon, 18 Sep 2023 18:29:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1695086942; x=1695691742; 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=Lndmxky9jXj7lYqBMwxO7GcFP2kIAWbIV8F+N+q5/bI=; b=Ao96PkPCuoZIDOZEIqZomOTsYB2jOSl6X7lzr+PcMXGgvyzXQ8CMmq39jjEsArM2VF UdW3wrjFMPbbY7+Tnh0VHvBMh0AyusCU/aJybI0S/4IK91XKDqkg13v00RQE+id2U11Q M+lYVLlT8JG4EYKQu5XNlxvF7bHy72RyFwXpMTCijF1glXfrd9Iru4qtNgSkNHumnmc4 mTT8WbnBhbW718MB2If+GfLg3aBkZ8uVJPzT7MxNtoVP26LWPBJUyIT+l4OABAmjDOef pMLPszbSosq4kjWmNnx4n/H+U6mpHim2jKH5GJ+vVm9Fdlvjarp48jEL4UulDaVi0aTB F4aA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1695086942; x=1695691742; 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=Lndmxky9jXj7lYqBMwxO7GcFP2kIAWbIV8F+N+q5/bI=; b=MxRayToFCwe34fzqBu8WGNJSx3HfjS2bCQEpEeTFfPQFIB1bLzTIXRoorcvCocQXsO 2D3wo3m4wJrQziCnqHBk8W0nbpp65kpDGa/n1GLHgh6XPAKFdcCjQN3E1V95HCqbo7Fr W0vxWNssRI0QsvnCcnL1wJ1+K5pbY8zFF6hTBPjpj1S3zRGmul3tvSzRcQxJYRFLdlc6 7uwb5+TYr057ldwcv9e6TlRs6j/zTIcVfnZ/EKimPVmwKLTsK969dQm5MVxvpUkU+zrk +uZ7JzJYXKOTADXfpNwfcLxdO5WuIXOZmsacMyoqGlvgcte9dqNIhZHWwug0Wp+hk4kY yQrQ== X-Gm-Message-State: AOJu0Yyo2etQPc0HTSl7FJvK3L70sCw2vEU2bcvKD+kr7A1oRs4dIu/n ecZLDB/51igKZCjz6TyRwAg= X-Google-Smtp-Source: AGHT+IH80EmWqQe79UQbrRooLNKV6tqDabobJc2l/o3eCttQeCzXF3VHuuMpx/A380A1RFabBl//5A== X-Received: by 2002:a4a:d208:0:b0:56c:d297:164c with SMTP id c8-20020a4ad208000000b0056cd297164cmr10360248oos.4.1695086942282; Mon, 18 Sep 2023 18:29:02 -0700 (PDT) Received: from nathanxps13 ([2600:1700:48f8:340f:50f9:2009:9d5e:e8d1]) by smtp.gmail.com with ESMTPSA id 129-20020a4a1d87000000b00573a7d8f382sm5178292oog.36.2023.09.18.18.29.01 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 18 Sep 2023 18:29:01 -0700 (PDT) Date: Mon, 18 Sep 2023 18:28:58 -0700 From: Nathan Bossart To: Tom Lane Cc: Robert Haas , Alvaro Herrera , Andrew Dunstan , pgsql-hackers@lists.postgresql.org Subject: Re: Inefficiency in parallel pg_restore with many tables Message-ID: <20230919012858.GA2664151@nathanxps13> References: <20230901205248.GA3184752@nathanxps13> <20230902185521.GA3414119@nathanxps13> <20230904230829.GA3826808@nathanxps13> <2393313.1694363710@sss.pgh.pa.us> <20230913183450.GA1042742@nathanxps13> <20230913224753.GA1237642@nathanxps13> <3031359.1694649699@sss.pgh.pa.us> <20230914034539.GA1468515@nathanxps13> <20230918212232.GA2660216@nathanxps13> <264174.1695086600@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <264174.1695086600@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Sep 18, 2023 at 09:23:20PM -0400, Tom Lane wrote: > Nathan Bossart writes: >> For now, I've committed 0001 and 0002. I intend to commit the others soon. > > bowerbird is unhappy with this. I suppose you missed out updating > the src/tools/msvc/ scripts. (Weren't we about ready to nuke those?) I saw that and have attempted to fix it with 83223f5. I'm still waiting for an MSVC animal to report back. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com