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.96) (envelope-from ) id 1wSNcp-00394H-3B for pgsql-hackers@arkaria.postgresql.org; Wed, 27 May 2026 23:25:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wSNcm-00A4Pj-1c for pgsql-hackers@arkaria.postgresql.org; Wed, 27 May 2026 23:25:21 +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.96) (envelope-from ) id 1wSNcm-00A4PZ-0k for pgsql-hackers@lists.postgresql.org; Wed, 27 May 2026 23:25:21 +0000 Received: from mail-vk1-xa32.google.com ([2607:f8b0:4864:20::a32]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wSNck-00000001leu-2t59 for pgsql-hackers@postgresql.org; Wed, 27 May 2026 23:25:20 +0000 Received: by mail-vk1-xa32.google.com with SMTP id 71dfb90a1353d-575320e6f2aso9839472e0c.0 for ; Wed, 27 May 2026 16:25:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1779924316; x=1780529116; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=CiFcEXsJRF6Y3vX/rAIKcd2oyNK40MYmTezKxvUWq0g=; b=sKHgwP04OYDM7QK0aC++Usqgssr+nvnP9/pgEWJwGWbGZgw9fd+SLMBbHkbL7aAX3j 2QiA8jbETk+asjqjMgHtpm3EDkXgXaOjm4mqCo4C0kLCx6jmiqS0kAevJDSfmNHyHDYq m1XY9hHOIERroQhuWWA8xIyOd6UD8/mfrbsfAXN533FhK63Z18eTnjq5Jt2j2pK5HXUc eFyQ3loPZ8b9pRDBiaogamJ78An4Lu9OiZ2BR1HfrXi9UahnwvF4V5pdMeq7Tg3Cad1/ WNmQA68snzZgKoXD0z9snv4rApk+wCC3XIOD8JtUPfB3cyP8KlTbfsB244uISRvL+Eh4 mAmQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779924316; x=1780529116; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=CiFcEXsJRF6Y3vX/rAIKcd2oyNK40MYmTezKxvUWq0g=; b=aG9Cfm82lYiM1yRNIJtjUcDBv4h6AoTLZafq4Mrk+ihjFvu9Oah7I+KXlnvF+HLCNf N/syokrhmfMbgNOZ4rqAvdhOR5HH6L+FHRcx/706Y+qAaCIwyzG09yEt9AC0sYL9cJAn vrHiDthux9SO8uNaqUTSj7Q9thq7iAMZITFe3xXWU5oHjiPmBG+G/lli/qaRWX0KUo9V AMm3QBiSjez7GX6v1hV1mUMWGy1iGj4huy7fRaVsjs9q7iuNHfYYeAcWYSd+qdFWgJ5M Fb0Lu4WkKGuD4vV+WYVdgox3okCN2NrVGxhDm7fWl8V+2ZJRnt2d7PDZNyyL/zvxrz8R NqOQ== X-Forwarded-Encrypted: i=1; AFNElJ8ZT/tHz5Tk2YruKW8RldFD+G1M7zODlUe1jDTsQL6mPGbgOfpgufKu5LMU4YgVkzuM6VSLdjhS1lQxpxHB@postgresql.org X-Gm-Message-State: AOJu0YwlUJMsg02FdxflqwXnDr2jlytho291XmaRgRxVF+ov5HabU1Ka 6hwSGfVvxFxc+/sBf2VrQkrR75/mqNenYjWrtN7kXg0bnaxXgiXPoP++ X-Gm-Gg: Acq92OE6Y+JVC9w4gT1fWVmTHKby0jNrE60OE9ZRVXrXOdrEDQZ5M2PD451n5SoLmIj iUVaetHWqTG3t20d/aN534Yhtdzt8Z0qk8Ts/IXyLFHzfTtLK/SoOcjSgGIfX8nc74BhkK6Ht2R C6iszsQqYcyGn47ZT7actvRGvCVPZ2SQwjPRNMa9E/ypWAlx3hjNg5a9UZNhAaf6B3xwfQkbgBy 4qoSOpAN/vwg13xdlQ69DRtdOuRD6/cWwOsBu8cF9aQB3LWaxqdLP0kkjhNEV3RahOPvkOqZ+pJ DclXgJ/KcHxHb01dZq2VG5SdDuvWGH+AzPmn0R6D/imP+PPzmUCuTmG/aCUQYqO5bKJ21aexC7C RQTW/HSLs8ANcSc5SoWydHFL+2k3EHszXf9wNjJsZ06ldREI5XB5ho9253Jwahq6gyt6TYiYdNE cK8e+W0sxqOPGpei61MCzBCegDYArXqz65s+E7nNxo8E6zi9EFtL8eK63fUKmSmQGFWLEEvBNP0 5Grr18FG140h9aBHS3+qsJakPlV5WUzFZw= X-Received: by 2002:a05:6122:4d12:b0:56f:b0bd:2276 with SMTP id 71dfb90a1353d-586595ddac7mr14385275e0c.0.1779924316419; Wed, 27 May 2026 16:25:16 -0700 (PDT) Received: from ?IPV6:2804:14d:328a:a59c:e478:6aba:413:6a85? ([2804:14d:328a:a59c:e478:6aba:413:6a85]) by smtp.gmail.com with ESMTPSA id 71dfb90a1353d-586f2f791d1sm22229108e0c.5.2026.05.27.16.25.13 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 27 May 2026 16:25:15 -0700 (PDT) Message-ID: Date: Wed, 27 May 2026 20:25:12 -0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: postgres_fdw: Use COPY to speed up batch inserts To: solaimurugan vellaipandiyan Cc: Masahiko Sawada , Andrew Dunstan , jian he , Tomas Vondra , pgsql-hackers@postgresql.org References: <72ec1708-0c02-4ae9-b4f5-ee2bac5fd2f3@gmail.com> Content-Language: en-US From: Matheus Alcantara In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 07/05/26 08:38, solaimurugan vellaipandiyan wrote: > Hi all, > > Thank you for the updated Patch. > > ... > > Looking forward to more feedback on this. > Hi, Thank you for reviewing and testing the patch. I've just posted a new version [1] removing the duplicated code. [1] https://www.postgresql.org/message-id/DITUGI3X54S8.346G3XFY7DRDK%40gmail.com -- Matheus Alcantara EDB: https://www.enterprisedb.com