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 1qiPwk-006N4T-1e for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Sep 2023 01:54: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 1qiPwi-005VMC-2o for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Sep 2023 01:54:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qiPwh-005VLv-OR for pgsql-hackers@lists.postgresql.org; Tue, 19 Sep 2023 01:54:35 +0000 Received: from mail-ot1-x329.google.com ([2607:f8b0:4864:20::329]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qiPwf-005MO5-2N for pgsql-hackers@lists.postgresql.org; Tue, 19 Sep 2023 01:54:34 +0000 Received: by mail-ot1-x329.google.com with SMTP id 46e09a7af769-6c0e8345c1eso3500458a34.0 for ; Mon, 18 Sep 2023 18:54:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1695088472; x=1695693272; 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=MREPen3FzKvxFZZAJpew3xcY9himQ0k9Uxohvv9Xw9Y=; b=LxUCAtw4bSsM7gEeP4UGVvBqjn3hBZ6GwGlCc7osBTU/F6WHYl/oFNEFQtBJIogJfD Q9fGH5F7G7Gq0MV+rvYGaPd3HdROdnhJ5Cn1qzIMle+x+lzbi4ByMnU6siKizOz50EmT F08CiksLJhMwFczGxbikTRHjpk48gYyec04q1m1cM5WD+Lpy3yfbGD8MmMOC7DrRlc9I YdL1OjG5q1BNspqXzSNCgf7029fa9pB8nqHBECSEjN5+WDXUluSQp+XNj37K7Yq3fbnq 22Zbyn+A+SwAEfAMImVJpeQ7rHID5RwhEqbyV0CPI+PhCRdYFFrJgbZ59vsR54DS2dIB 5q/A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1695088472; x=1695693272; 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=MREPen3FzKvxFZZAJpew3xcY9himQ0k9Uxohvv9Xw9Y=; b=cxrM6eOiT3/QaqzzW/2EukEvOvtGo51cRdvbRWzXHVGjWQyf89RrOhtBLE3BXWEuz8 R0o+LsLwl9w3BZYNlf3wFBBrmXcdj9BZFpBB6CqaDmlaF/S+9fMJrjZvXza27NuEjIsJ B19IP2jDtGIchk6WVsBnSL8mrU5WPWP0isWnkpd6bDSO3lip+9jWiy2zzjrnYdlFMUTy UIz2YzpVj0GMmSQJP1H4NV2ASS6nRCoB8xUyWwBzwWcZsBUEq7S0b3ODCQ8MNDrmEkOd bOGYEBmtH4d1KMuzvUcmDqp26aRsNNdJhbFJxcdSRR9Tyqs1MfEZSw9MVen6OHyJCr6Y kcMg== X-Gm-Message-State: AOJu0YzBj7d+UFbj91je2znS16b3NXZkUEC5G1BqMyK4fQsnAs2r6FYO JZMhkVym1fXY1N3NwWP7Yac= X-Google-Smtp-Source: AGHT+IFGdNRN2JU+UNihH2n/3jvlJk6vjDZECoTzBzL/stgn/ERDd8sS5W6asu0ojHWp5dxrtebcYQ== X-Received: by 2002:a05:6830:4d0:b0:6c0:b3fb:2e65 with SMTP id s16-20020a05683004d000b006c0b3fb2e65mr12369697otd.16.1695088472382; Mon, 18 Sep 2023 18:54:32 -0700 (PDT) Received: from nathanxps13 ([2600:1700:48f8:340f:50f9:2009:9d5e:e8d1]) by smtp.gmail.com with ESMTPSA id q24-20020a05683033d800b006b8b55297b5sm4807617ott.42.2023.09.18.18.54.31 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 18 Sep 2023 18:54:31 -0700 (PDT) Date: Mon, 18 Sep 2023 18:54:28 -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: <20230919015428.GA2664610@nathanxps13> References: <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> <20230919012858.GA2664151@nathanxps13> <266008.1695087363@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <266008.1695087363@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:36:03PM -0400, Tom Lane wrote: > But in any case, how long are we keeping src/tools/msvc/ ? From a skim of [0], it seems like it could be removed now. I see a couple of work-in-progress patches from Andres [1] that would probably serve as a good starting point. I won't have much time for this for the next few weeks, so if someone else wants to pick it up, please feel free. [0] https://postgr.es/m/20230408191007.7lysd42euafwl74f%40awork3.anarazel.de [1] https://github.com/anarazel/postgres/commits/drop-homegrown-msvc -- Nathan Bossart Amazon Web Services: https://aws.amazon.com