postgres_fdw batch insert error out when set batch

postgres_fdw batch insert error out when set batch_size > 65535

3133

Title

postgres_fdw batch insert error out when set batch_size > 65535

Topic

Bug Fixes

Created

2021-05-25 09:24:43

Last modified

2021-06-09 00:54:49 (3 years, 5 months ago)

Latest email

2021-06-14 12:38:47 (3 years, 5 months ago)

Status

2021-07: Committed

Target version

Authors

Hou Zhijie (houzj)

Reviewers

Bharath Rupireddy (bharathrupireddy)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/3133
git checkout commitfest/cf/3133

Emails

Fdw batch insert error out when set batch_size > 65535: First at 2021-05-21 02:48:05 by "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com>
Latest at 2021-06-14 12:38:47 by Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com>
Latest attachment (v1-0001-enhance-batch-insert-test-case.patch) at 2021-06-13 15:25:23 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com>
    Attachment (v1-0001-enhance-batch-insert-test-case.patch) at 2021-06-13 15:25:23 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (postgres_fdw_batch_test.patch) at 2021-06-13 13:54:57 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Make-sure-postgres_fdw-batching-does-use-too-many-pa.patch) at 2021-05-30 19:51:54 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v5-0001-Adjust-batch_size-to-not-exceed-max-param-limit-o.patch) at 2021-05-26 13:55:44 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Adjust-batch_size-to-not-exceed-max-param-limit-o.patch) at 2021-05-26 06:57:24 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v3-0001-limit-the-fdw-batch-size.patch) at 2021-05-25 07:38:23 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v2-0001-limit-the-fdw-batch-size.patch) at 2021-05-21 07:49:55 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (0001-limit-the-fdw-batch-size.patch) at 2021-05-21 02:48:05 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)

History

When	Who	What
2021-06-09 00:54:49	Hou Zhijie (houzj)	Closed in commitfest 2021-07 with status: Committed
2021-06-09 00:54:49	Hou Zhijie (houzj)	Changed committer to fuzzycz
2021-05-25 09:25:19	Hou Zhijie (houzj)	Changed reviewers to Bharath Rupireddy (bharathrupireddy)
2021-05-25 09:25:19	Hou Zhijie (houzj)	Changed authors to hou zhijie (houzj)
2021-05-25 09:24:43	Hou Zhijie (houzj)	Attached mail thread OS0PR01MB571603973C0AC2874AD6BF2594299@OS0PR01MB5716.jpnprd01.prod.outlook.com
2021-05-25 09:24:43	Hou Zhijie (houzj)	Created patch record