Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l6r34-0006iG-BO for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Feb 2021 08:28:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l6r33-0000um-A3 for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Feb 2021 08:28:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l6r33-0000ue-0n for pgsql-hackers@lists.postgresql.org; Tue, 02 Feb 2021 08:28:33 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l6r31-0006rO-1t for pgsql-hackers@postgresql.org; Tue, 02 Feb 2021 08:28:32 +0000 Received: from ip-192-168-0-192.is74.loc (pool-77-222-110-162.is74.ru [77.222.110.162]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id 9709621C245C; Tue, 2 Feb 2021 11:28:28 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1612254509; bh=I1W2p6MQI+aoxIgnwHIFmkNLp/AQ5buiWWDFzTz1FB0=; h=Subject:To:Cc:References:From:Date:In-Reply-To; b=efKfSWFUw4JgTiZHJ0/W9P541ATqhTCzfC24winAcor0ajQuC4qIBFpBfE9YfWTOb Gt2cOpSR0JlO56L3X51SMF57FpWrBhdOWqOi8v4467o+YkOpCo+eI/9H2QXo/x9I7Z 8B1N/la6C05EX9fsdTp+diNXwh1i7pzElUYyNdKc= Subject: Re: [POC] Fast COPY FROM command for the table with foreign partitions To: "tsunakawa.takay@fujitsu.com" Cc: "tanghy.fnst@cn.fujitsu.com" , Alexey Kondratov , Michael Paquier , Ashutosh Bapat , Ashutosh Bapat , Etsuro Fujita , PostgreSQL-Dev , Tomas Vondra , "houzj.fnst@cn.fujitsu.com" , Amit Langote References: <9bff5ccc-8649-9699-1cdd-82b53164f9bb@postgrespro.ru> <7166ded145a947fbb11b67ebe68041f3@G08CNEXMBPEKD05.g08.fujitsu.local> <2b465f4cdeeb4a78b3096d31e8af7c77@G08CNEXMBPEKD05.g08.fujitsu.local> <9862b608-884b-da1f-afb5-2ee5f2396257@enterprisedb.com> <6160196a-88a4-ded8-1047-cec16537a111@postgrespro.ru> From: Andrey Lepikhov Organization: Postgres Professional Message-ID: <95b3e446-92ec-f01f-2035-5f5509e6e016@postgrespro.ru> Date: Tue, 2 Feb 2021 13:28:27 +0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.16; rv:78.0) Gecko/20100101 Thunderbird/78.6.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2/2/21 11:57, tsunakawa.takay@fujitsu.com wrote: > Hello, Andrey-san, > > > From: Tang, Haiying >>> Sometimes before i suggested additional optimization [1] which can >>> additionally speed up COPY by 2-4 times. Maybe you can perform the >>> benchmark for this solution too? > ... >> But the patch no longer applies, I tried to apply on e42b3c3bd6(2021/1/26) but >> failed. >> >> Can you send a rebased version? > When do you think you can submit the rebased version of them? (IIUC at the off-list HighGo meeting, you're planning to post them late this week after the global snapshot patch.) Just in case you are not going to do them for the moment, can we rebase and/or further modify them so that they can be committed in PG 14? Of course, you can rebase it. -- regards, Andrey Lepikhov Postgres Professional