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 1qimzE-007qDd-5Q for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Sep 2023 02:30:44 +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 1qimzC-00Dc9k-DF for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Sep 2023 02:30:42 +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 1qimzC-00Dc9W-38 for pgsql-hackers@lists.postgresql.org; Wed, 20 Sep 2023 02:30:42 +0000 Received: from mail-oo1-xc36.google.com ([2607:f8b0:4864:20::c36]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qimz8-006EA1-QJ for pgsql-hackers@lists.postgresql.org; Wed, 20 Sep 2023 02:30:41 +0000 Received: by mail-oo1-xc36.google.com with SMTP id 006d021491bc7-571194584e2so3884579eaf.3 for ; Tue, 19 Sep 2023 19:30:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1695177036; x=1695781836; 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=X49lfnBjeGj9qzCYG+qAHySGbW0sTMTnYTRQ1ByDDy0=; b=ksxfTTq1eL59zJnq6NuW3UKv+q+a0ySUKCyxDozMXz0iB+mxvvbIF69Mm1RERjMAUD zN99j1MIhqD3o9eAh5k2a43w69epVr5a4266OctVoejq3y9B0WvzpyubMeLyWhEtEzd3 CERED9E74zRRlqtkggjy1TeuEcfXbamZwUPm7T1jtOgqoMVR3kfS9vl0e2qjXSMniBMm XDYoOlomw1ejZbb1YR0TW321Q0rvAb7fzulUm0aXaG8JsLOhw4A02o+EiDgn063s9sYw ISgrJCip0AoAO6QSv9sE3wvhBUG3phMRrrc9PSWTySqYWwN0Hdwg2Fi8nfO6cue2lS/s xL4w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1695177036; x=1695781836; 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=X49lfnBjeGj9qzCYG+qAHySGbW0sTMTnYTRQ1ByDDy0=; b=WHzs+MKtkcPZ7Sv63Qes8o8UeryDyNTIRxTaOBeiwodPFB04xgF+iUfgsD9MaEUAqe V96OYXDFIv/0tT77ZZUI8hCxx0RUbt8bmX1eo2CNVs59qviQO0OlEzUQ3UvjduR7iPIG 6o4vzDpkh3m2b1x5dkMoW0rx+8uPby0S6NvwczUxmx+9KNUw+4+kNcq3DIVX04qCHOSV y3Z030gd7o+Z1XxiR+q2jJYSea+RAyXzbLBl0CEee7UogqOP2fEopoRn1ZRLXmHKaeDj s7LAokLD5F7gAgI8Ra1jmQvEcNxVgL7BdBSR1olX7n+5KAdglCVDow4+bqS7+I6lgTTE p0gQ== X-Gm-Message-State: AOJu0YwWW0134c60c3ZKvsJkm/LY/+bwxjY1urUhsYskA1QkIklrIM4L V+xpoktMpv5fvO7/2lXbk4A= X-Google-Smtp-Source: AGHT+IG6AvOAKTq03mnA8l/W1ROY1u/lA3vspzqMFZBpOV384aqn4oj/dlXSeYxak1B3+/rx7YlO5w== X-Received: by 2002:a4a:3050:0:b0:570:be00:5e14 with SMTP id z16-20020a4a3050000000b00570be005e14mr1372872ooz.8.1695177036045; Tue, 19 Sep 2023 19:30:36 -0700 (PDT) Received: from nathanxps13 ([2600:1700:48f8:340f:5c41:f361:96fa:4f97]) by smtp.gmail.com with ESMTPSA id l5-20020a4a4345000000b0057b12c308a1sm1664077ooj.41.2023.09.19.19.30.34 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 19 Sep 2023 19:30:35 -0700 (PDT) Date: Tue, 19 Sep 2023 19:30:33 -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: <20230920023033.GA2954035@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> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20230918212232.GA2660216@nathanxps13> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Sep 18, 2023 at 02:22:32PM -0700, Nathan Bossart wrote: > For now, I've committed 0001 and 0002. I intend to commit the others soon. I've committed the rest of the patches. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com