Re: Allow batched insert during cross-partition updates
Amit Langote <amitlangote09@gmail.com>
From: Amit Langote <amitlangote09@gmail.com>
To: Etsuro Fujita <etsuro.fujita@gmail.com>
Cc: Andres Freund <andres@anarazel.de>, vignesh C <vignesh21@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>,
"houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>, Zhihong Yu <zyu@yugabyte.com>, "gkokolatos@pm.me" <gkokolatos@pm.me>, PostgreSQL-development <pgsql-hackers@postgresql.org>,
Tomas Vondra <tomas.vondra@enterprisedb.com>, "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>, Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Date: 2022-12-14T13:28:46Z
Lists: pgsql-hackers
On Wed, Dec 14, 2022 at 6:45 PM Etsuro Fujita <etsuro.fujita@gmail.com> wrote: > On Thu, Dec 8, 2022 at 8:01 PM Etsuro Fujita <etsuro.fujita@gmail.com> wrote: > > On Thu, Dec 8, 2022 at 5:00 PM Amit Langote <amitlangote09@gmail.com> wrote: > > > Updated patch attached. > > > > I will review the patch a bit more, but I think > > it would be committable. > > One thing I noticed is this bit: > > -- Clean up > -DROP TABLE batch_table, batch_cp_upd_test, batch_table_p0, > batch_table_p1 CASCADE; > +DROP TABLE batch_table, batch_table_p0, batch_table_p1, > batch_cp_upd_test, cmdlog CASCADE; > > This would be nitpicking, but this as-proposed will not remove remote > tables created for foreign-table partitions of the partitioned table > ‘batch_cp_upd_test’. So I modified this a bit further to remove them > as well. Also, I split this into two, for readability. Another thing > is a typo in a test-case comment: s/a single INSERTs/a single INSERT/. > I fixed it as well. Other than that, the patch looks good to me. > Attached is an updated patch. If there are no objections, I will > commit the patch. Thanks for the changes. LGTM. -- Thanks, Amit Langote EDB: http://www.enterprisedb.com
Commits
-
Allow batching of inserts during cross-partition updates.
- 594f8d3776af 16.0 landed
-
Fix handling of pending inserts in nodeModifyTable.c.
- ffbb7e65a873 16.0 cited
-
Postpone some stuff out of ExecInitModifyTable.
- c5b7ba4e67ae 14.0 cited
-
Fix tuple routing to initialize batching only for inserts
- 927f453a9410 14.0 cited