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 1qiLha-006Aj8-F0 for pgsql-hackers@arkaria.postgresql.org; Mon, 18 Sep 2023 21:22:42 +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 1qiLhY-003iQm-Ti for pgsql-hackers@arkaria.postgresql.org; Mon, 18 Sep 2023 21:22:40 +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 1qiLhY-003iQY-Ih for pgsql-hackers@lists.postgresql.org; Mon, 18 Sep 2023 21:22:40 +0000 Received: from mail-oi1-x232.google.com ([2607:f8b0:4864:20::232]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qiLhV-005yO1-6i for pgsql-hackers@lists.postgresql.org; Mon, 18 Sep 2023 21:22:40 +0000 Received: by mail-oi1-x232.google.com with SMTP id 5614622812f47-3ab29af398aso3605725b6e.1 for ; Mon, 18 Sep 2023 14:22:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1695072155; x=1695676955; 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=uq8uMHbKys3bh5go3x2njMd0RzzjnSBXIcbKKVdoOkg=; b=ljdb/gr0NGeAUfcePNi4FoNjbmD9FBK1znbCvO1s/hAhHi+BIQrr5B4rggV5+WOOqN 3El/Ng5OrymGFpPPI1e+3VDu6qiV34hbvfRvw7AienI49Up7BYcO7S8yyGAqt/J62o8p P0jjQhVwjcMsmxUfIwRKnZ7IxP7NgcCHcjfHh6ZPNex7lCu08wE1rr6+BPszlr2hkpav znfkUVI+c1qnx/QJFbIVUApw/0J2bJPzmkUnzmq68yVg91/4ewCeTSJfCr6pXpMTeLz2 yJX1cRkmy5tXZrd8j/qXmZghTIk49S645UmgV2BoJl4691IkPX/gzed/H0aqqxVXYzSQ kaCw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1695072155; x=1695676955; 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=uq8uMHbKys3bh5go3x2njMd0RzzjnSBXIcbKKVdoOkg=; b=T2XQv08+GhxUpsgEA8GSWotO0SNvUh0Ca32Gx1r+mX28HZyW3n5Ut+/kwa6tJtYOP3 L+fgE4f8yMUo460wHJAFeHRfe9oXm9j9I3iYMChtC8fjJ+1F6LZw/IfDPU42c/pCAHbk ELPXi3SkIjltUyNF6GJCZcbsviAp5RKS8gXL0OY2oG6Yk74cWhDDU7QaCTFBrTiNSnWy Gwr+FfTR9tb/SIcZ9N3ivdxp+YRxcbXGDTTd1OAduhIk6W4xV4zOk6ZTi3In74vpf4BQ dBqd7p1IGQF5QXsfxP2MoWXf1gNsgkjp71e0pu1t/Ikzu7dZzDH7ecKcUQdoIVi7XSg+ SpJg== X-Gm-Message-State: AOJu0YzDj9yvdKRIVH5ZhOdwf3uWf5PH4c8dEfw5M17GCLfIWUP++ss3 E5Zi1mM5r3a9mb+hQCGf368= X-Google-Smtp-Source: AGHT+IFoIhG1jxjPtdiSUm2b90/8rO+dm4i98WK6bnenKi8AexMvlGgU/HFadmLlOgyolj59+mQmVQ== X-Received: by 2002:a05:6808:638b:b0:3a8:5c24:4ef6 with SMTP id ec11-20020a056808638b00b003a85c244ef6mr9878522oib.58.1695072155534; Mon, 18 Sep 2023 14:22:35 -0700 (PDT) Received: from nathanxps13 ([2600:1700:48f8:340f:46e8:a83d:5376:87fd]) by smtp.gmail.com with ESMTPSA id z14-20020a056808028e00b003a371c611f6sm4387901oic.18.2023.09.18.14.22.34 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 18 Sep 2023 14:22:34 -0700 (PDT) Date: Mon, 18 Sep 2023 14:22:32 -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: <20230918212232.GA2660216@nathanxps13> References: <20230725185336.GA2911441@nathanxps13> <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> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20230914034539.GA1468515@nathanxps13> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk For now, I've committed 0001 and 0002. I intend to commit the others soon. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com