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 1l2MSz-0003dU-12 for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Jan 2021 23:00:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l2MSx-0002QM-Uv for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Jan 2021 23:00:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l2MSx-0002QE-Ns for pgsql-hackers@lists.postgresql.org; Wed, 20 Jan 2021 23:00:43 +0000 Received: from mail-ed1-x52a.google.com ([2a00:1450:4864:20::52a]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1l2MSu-0001TY-5q for pgsql-hackers@postgresql.org; Wed, 20 Jan 2021 23:00:42 +0000 Received: by mail-ed1-x52a.google.com with SMTP id g24so245505edw.9 for ; Wed, 20 Jan 2021 15:00:39 -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=osWN3hehmnY7jljipzxbuTkeozxr8+FyzdPB1CXO6Ww=; b=uyRB1q8MqbobZyHLP1iv35ryPjmHcKTRhXKiSZQfm02lqM1Ym3Yc/zADgTN+3BE4FA WyruMRGqa4xJLGvWeb40Ae/IVO+xz7I2+9299whdLvBHSJAHGkFIALZZ0PB4jS1kVNsL CVT6zQMBKl+hkmU9RPpFoER4GJG6yBr5WtWQEF2XurV0b7IpWU/CQiEqzBtyXsQZP34H D7u5KnUyJwmFcyIo0GH9VlCOGFndPrq0xy8y6jSW8w505d+NQjecmoL2NsnWr5RGhW9h B14w2U23xfcVeR+Ul2H56okgfsbZxb7pVkXqCGsqseY9S7BcQbeipVzHdBbOfZZW8zMQ Zbhg== 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=osWN3hehmnY7jljipzxbuTkeozxr8+FyzdPB1CXO6Ww=; b=qPqA2Q3oi5TJWV6FvPI5+RLec0oXPr7kl/Bc+otwD/utwj+oOQttY89a82qwWQyG+M GPh6a5l1rwsIGv08H6/amDhpEyqb6zjNnDmalUOMSWSMnR8bwuOVQ3s/GTxlPtFph9Qn 5rA7iQBv1apHctjF5nj1/pZFCD8jFojwfLmIMEX6l7d6WDbW7DZjq3nSqwv43gcVwgzu eJH7SZn3IOKRhIKjHpl9/LFHcFHBbFdK0UJ/fD34OuGARRWtBp8zRPyeCf5c8A/bww6t heTbOsAdlVXfmv5Es6kBbgha+MGO9FANjje2LqcAjHtzJBBE8uNzdhJoUVF2c6+204Yp jcfw== X-Gm-Message-State: AOAM532RlNAza0l5ScFFyaViZUWND2OgttGXvTx1hwoYrIUb5SWyHeEV 5Ck1ei/9MN3/p7qwlWPvohDZMvjDjfvYtVtZ6Eupxm37pdF8Pbo55w/2JfLNq5k7GguTbd4tdEX aHimzLkwcVWjERdHaLMIkkNt02ReiM5e+1VDgDpBytVc5RmR7ugws2htdMAPV9DJ6hJafK4LzQE JclIWXFPufVco1IgpTEwOsfW4IIqEjeZUPwaeSM8jK0HQ5SxNN9eQwOLF55qrLKiSjHXlZpiOE0 FiwcYys7G9gyu4tX+P8R4jeWdGQVyvVP50Oow== X-Google-Smtp-Source: ABdhPJzAm/Pxx/V/ozt+6ZtFRtbv4MtC+t8f0A5sbzJGqVavE3N5Xd2Nzl3OIu7gaR0WUWMzmXs8gA== X-Received: by 2002:a05:6402:2c5:: with SMTP id b5mr9415035edx.258.1611183637907; Wed, 20 Jan 2021 15:00:37 -0800 (PST) Received: from [10.137.0.20] (ip-86-49-253-127.net.upcbroadband.cz. [86.49.253.127]) by smtp.gmail.com with ESMTPSA id k16sm1464307ejd.78.2021.01.20.15.00.36 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 20 Jan 2021 15:00:36 -0800 (PST) Subject: Re: POC: postgres_fdw insert batching To: Amit Langote Cc: "tsunakawa.takay@fujitsu.com" , "Andrey V. Lepikhov" , Tomas Vondra , "pgsql-hackers@postgresql.org" References: <20200628151002.7x5laxwpgvkyiu3q@development> <16fcfd4c-2d5e-67f7-fa69-9b5d119bac52@enterprisedb.com> <9d94c863-ce7c-ea7f-6b84-834c98929e2f@enterprisedb.com> From: Tomas Vondra Message-ID: <7e70a11e-cf5d-2e5f-a802-274c5e0e236b@enterprisedb.com> Date: Thu, 21 Jan 2021 00:00:34 +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; format=flowed 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 OK, pushed after a little bit of additional polishing (mostly comments). Thanks everyone! -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company