Horton

Re: POC: postgres_fdw insert batching

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: "Andrey V. Lepikhov" <a.lepikhov@postgrespro.ru>, pgsql-hackers@postgresql.org
Date: 2020-10-01T04:12:54Z
Lists: pgsql-hackers 
On Sun, Jul 12, 2020 at 02:11:01AM +0200, Tomas Vondra wrote:
> Because I was focused on speeding-up inserts, and that is not using
> CopyMultiInsertBuffer I think. I agree the way the tuples are stored
> may be improved, of course.

The CF bot is telling that the regression tests of postgres_fdw are
crashing.  Could you look at that?
--
Michael

Commits

  1. Fix tuple routing to initialize batching only for inserts

  2. Fix pointer type in ExecForeignBatchInsert SGML docs

  3. Fix initialization of FDW batching in ExecInitModifyTable

  4. Implement support for bulk inserts in postgres_fdw