postgres_fdw insert batching

Edit

ID 2620

Title postgres_fdw insert batching

Topic Performance

Created 2020-06-28 20:12:12

Last modified 2021-01-20 23:00:45 (3 years, 10 months ago)

Latest email 2021-01-25 04:21:39 (3 years, 9 months ago)

Status

2021-01: Committed

2020-11: Moved to next CF

2020-09: Moved to next CF

2020-07: Moved to next CF

Target version 14

Authors Takayuki Tsunakawa (maumau)

Reviewers Become reviewer

Committer Tomas Vondra (fuzzycz)

Links CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/2620
git checkout commitfest/cf/2620

Emails

POC: postgres_fdw insert batching: First at 2020-06-28 15:10:02 by Tomas Vondra <tomas.vondra at 2ndquadrant.com>
Latest at 2021-01-25 04:21:39 by "tsunakawa.takay at fujitsu.com" <tsunakawa.takay at fujitsu.com>
Latest attachment (v2-0001-Prevent-FDW-insert-batching-during-cross-partitio.patch) at 2021-01-24 12:31:42 from Amit Langote <amitlangote09 at gmail.com>
    Attachment (v2-0001-Prevent-FDW-insert-batching-during-cross-partitio.patch) at 2021-01-24 12:31:42 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-Prevent-FDW-insert-batching-during-cross-partition-u.patch) at 2021-01-23 08:31:18 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (doc-fdw-batch-insert-fix.v1.patch) at 2021-01-22 05:50:49 from Ian Lawrence Barwick <barwick at gmail.com> (Patch: Yes)
    Attachment (modifytable-fix-3.patch) at 2021-01-21 02:00:42 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (modifytable-fix-2.patch) at 2021-01-21 01:42:03 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (modifytable-fix.patch) at 2021-01-21 00:21:29 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (valgrind.log) at 2021-01-20 23:52:25 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)
    Attachment (v12-0001-Add-bulk-insert-for-foreign-tables.patch) at 2021-01-19 03:50:03 from "tsunakawa.takay at fujitsu.com" <tsunakawa.takay at fujitsu.com> (Patch: Yes)
    Attachment (0001-Add-bulk-insert-for-foreign-tables-v11.patch) at 2021-01-18 17:56:23 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v10-0001-Add-bulk-insert-for-foreign-tables.patch) at 2021-01-18 06:51:45 from "tsunakawa.takay at fujitsu.com" <tsunakawa.takay at fujitsu.com> (Patch: Yes)
    Attachment (0001-Add-bulk-insert-for-foreign-tables-v9.patch) at 2021-01-14 15:05:25 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Add-bulk-insert-for-foreign-tables-v8.patch) at 2021-01-13 17:41:09 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Add-bulk-insert-for-foreign-tables-v7.patch) at 2021-01-13 14:43:29 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Add-bulk-insert-for-foreign-tables-v6.patch) at 2021-01-12 02:06:29 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v5-0001-Add-bulk-insert-for-foreign-tables.patch) at 2020-11-25 05:04:36 from "tsunakawa.takay at fujitsu.com" <tsunakawa.takay at fujitsu.com> (Patch: Yes)
    Attachment (v4-0001-Add-bulk-insert-for-foreign-tables.patch) at 2020-11-23 02:17:14 from "tsunakawa.takay at fujitsu.com" <tsunakawa.takay at fujitsu.com> (Patch: Yes)
    Attachment (v3-0001-Add-bulk-insert-for-foreign-tables.patch) at 2020-11-18 18:57:30 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (fdw.sql) at 2020-11-17 09:11:55 from "tsunakawa.takay at fujitsu.com" <tsunakawa.takay at fujitsu.com> (Patch: No)
    Attachment (fdw.sql) at 2020-11-10 00:45:50 from "tsunakawa.takay at fujitsu.com" <tsunakawa.takay at fujitsu.com> (Patch: No)
    Attachment (fdw.sql) at 2020-06-28 15:10:02 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)

History

When	Who	What
2021-01-20 23:00:45	Tomas Vondra (fuzzycz)	Closed in commitfest 2021-01 with status: Committed
2021-01-20 23:00:45	Tomas Vondra (fuzzycz)	Changed committer to fuzzycz
2020-12-01 11:04:35	Anastasia Lubennikova (lubennikovaav)	Closed in commitfest 2020-11 with status: Moved to next CF
2020-11-10 00:51:21	Takayuki Tsunakawa (maumau)	New status: Needs review
2020-10-30 04:51:47	Takayuki Tsunakawa (maumau)	Changed authors to Takayuki Tsunakawa (maumau)
2020-10-30 04:44:24	Takayuki Tsunakawa (maumau)	Changed targetversion to 14
2020-10-30 04:41:28	Takayuki Tsunakawa (maumau)	Changed targetversion to 13
2020-10-30 04:31:09	Takayuki Tsunakawa (maumau)	Removed maumau from reviewers
2020-10-30 04:30:24	Takayuki Tsunakawa (maumau)	Changed targetversion to 14
2020-10-30 04:30:24	Takayuki Tsunakawa (maumau)	Changed name to postgres_fdw insert batching
2020-10-08 03:25:02	Takayuki Tsunakawa (maumau)	Added maumau as reviewer
2020-10-01 04:13:13	Michael Paquier (michael-kun)	New status: Waiting on Author
2020-10-01 04:13:03	Michael Paquier (michael-kun)	Closed in commitfest 2020-09 with status: Moved to next CF
2020-08-02 22:08:07	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2020-07 with status: Moved to next CF
2020-06-28 20:12:12	Tomas Vondra (fuzzycz)	Attached mail thread 20200628151002.7x5laxwpgvkyiu3q@development
2020-06-28 20:12:12	Tomas Vondra (fuzzycz)	Created patch record

Edit