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 1kz1kM-0006Jj-0D for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Jan 2021 18:16:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kz1kK-00007V-U0 for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Jan 2021 18:16:52 +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 1kz1kK-00007M-NO for pgsql-hackers@lists.postgresql.org; Mon, 11 Jan 2021 18:16:52 +0000 Received: from mail-ed1-x533.google.com ([2a00:1450:4864:20::533]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kz1kH-0002w7-Rv for pgsql-hackers@postgresql.org; Mon, 11 Jan 2021 18:16:52 +0000 Received: by mail-ed1-x533.google.com with SMTP id c7so736978edv.6 for ; Mon, 11 Jan 2021 10:16:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=6zyJ4SvR1sQHj/WtOSn4eK478NjWkobohagzD0+5YzU=; b=GMcm6DqHIZFpgwO6aeyrDTwetJN38Ybejdmzn+0+aM3J2ufCNlMMg+GR+JQHB0S0Tg YFaBqaItjpsQwTEaE8IALV8AiYyV7QChK5ihRncMNUTqf4WzNVogfGmz0lq/rIqs8e2o PSXOuiOXkZ66mmfEBJXHcGcN5MqJKxLXyzhUsy4Tpmv6mRBy873AEqwHGUHEblXHToBf CW3BSnBpbzDGBBXK+/dMkQ40n2TNcXmL+ASB3ruGPP0eLT/GEp/GuY2h4YfXz7beaUgI /udlvTIjq9I6/fS8J9Lbe1X+g3c91Ak9G4BGxVXahQpwu17vRSmNZesvu4v2/iZbhWFz 9rIQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=6zyJ4SvR1sQHj/WtOSn4eK478NjWkobohagzD0+5YzU=; b=cC/dDOCwC08F7Vgx9+yU86Guqe+7pM4gVN0mu3fp6m+2YRLWg/xheapGvDMAPuO72f 7yoJKRNwJ5oFk6yqnYEKGLzqeo2+OHj0NKKxg7GEb8sqlxob+YYO16vl0FVATD0n6dE8 RZU8updncFIoTG9k+nBSdQTsvCSV5Xzqd7fH5CB1maX//oSNF/zUs8/tJM3OjEFa+RcR 8HLLsOIM5i57FPi7ME7fGO7iyO/IIfz/hXkH3LHZDDEaBXnVhsbwlE5Kv98y4MybBnh8 eBqYRGj7YOKZwqaTM1k+FLExhRVgZ0YFANYvSJhIOI+NnXYzWJ2L/qI5lLZhZsXGMEF8 S3kQ== X-Gm-Message-State: AOAM5325uFn+l77HdG1Fyu57hByY0mp/VlQJmJIdyFlMvOrsFEBzbT2D UUkwlBfkofR/MroEzszTCtWUxCUp6XUfXI3mEAqjCJSdBsfvrM2JDeut7idHre4U39u1lRHf5jM xZjG2Tv714dHmRw2xRP/uvF9NR0q8nXac+Qd1dDcZYlSkM4Sdrsl7SYahuONibQZnqpfWINHWy2 Q8ZsaNmfvjGlgxyFhVNEHZ3pmT9QYEGMM5PK/T X-Google-Smtp-Source: ABdhPJzkIxV+uiHH02A2QTEGNC4b+IXEGs2OO6sM2ZezbiWqA3+zXnrx4SON+Y3OvNyjfKGhzgdEew== X-Received: by 2002:aa7:c492:: with SMTP id m18mr478209edq.236.1610389008763; Mon, 11 Jan 2021 10:16:48 -0800 (PST) Received: from [10.137.0.4] (ip-86-49-253-127.net.upcbroadband.cz. [86.49.253.127]) by smtp.gmail.com with ESMTPSA id x20sm157149ejv.66.2021.01.11.10.16.47 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 11 Jan 2021 10:16:47 -0800 (PST) Subject: Re: [POC] Fast COPY FROM command for the table with foreign partitions To: Andrey Lepikhov , "Hou, Zhijie" , Amit Langote , "Tsunakawa, Takayuki" Cc: Alexey Kondratov , Michael Paquier , Ashutosh Bapat , Ashutosh Bapat , Etsuro Fujita , PostgreSQL-Dev , "Tang, Haiying" References: <8ddacbf0-d489-cd56-fecc-e09a7e02a7c1@postgrespro.ru> <9bff5ccc-8649-9699-1cdd-82b53164f9bb@postgrespro.ru> <7166ded145a947fbb11b67ebe68041f3@G08CNEXMBPEKD05.g08.fujitsu.local> <2b465f4cdeeb4a78b3096d31e8af7c77@G08CNEXMBPEKD05.g08.fujitsu.local> From: Tomas Vondra Message-ID: <9862b608-884b-da1f-afb5-2ee5f2396257@enterprisedb.com> Date: Mon, 11 Jan 2021 19:16:45 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.6.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi Andrey, Unfortunately, this no longer applies :-( I tried to apply this on top of c532d15ddd (from 2020/12/30) but even that has non-trivial conflicts. Can you send a rebased version? regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company