Overhaul UPDATE/DELETE processing

Edit
ID 2575
Title Overhaul UPDATE/DELETE processing
Topic Performance
Created 2020-06-02 04:19:11
Last modified 2021-03-31 16:01:54 (3 years, 6 months ago)
Latest email 2021-04-02 07:41:13 (3 years, 6 months ago)
Status
2021-03: Committed
2021-01: Moved to next CF
2020-11: Moved to next CF
2020-09: Moved to next CF
2020-07: Moved to next CF
Target version
Authors Amit Langote (amitlan)
Reviewers Tom Lane (tgl)Become reviewer
Committer Tom Lane (tgl)
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/2575
git checkout commitfest/cf/2575
Emails
making update/delete of inheritance trees scale better
First at 2020-05-08 13:32:50 by Amit Langote <amitlangote09 at gmail.com>
Latest at 2021-04-02 07:41:13 by Amit Langote <amitlangote09 at gmail.com>
Latest attachment (test_update_inh.sh) at 2021-03-31 12:54:04 from Amit Langote <amitlangote09 at gmail.com>
    Attachment (test_update_inh.sh) at 2021-03-31 12:54:04 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (heikki10.sql) at 2021-03-30 18:50:23 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: No)
    Attachment (heikki6.sql) at 2021-03-30 18:39:18 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: No)
    Attachment (v13-0001-Overhaul-how-updates-compute-new-tuple.patch) at 2021-03-30 04:51:15 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v12-0001-Overhaul-how-updates-compute-new-tuple.patch) at 2021-03-27 16:30:07 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v11-0002-Revise-how-inherited-update-delete-are-handled.patch) at 2021-03-26 15:21:44 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v10-0001-Overhaul-how-updates-compute-new-tuple.patch) at 2021-03-03 14:39:01 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Overhaul-how-updates-compute-new-tuple.patch) at 2021-02-16 13:42:57 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Overhaul-how-updates-compute-new-tuple.patch) at 2021-02-04 06:22:29 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Overhaul-how-updates-compute-new-tuple.patch) at 2021-01-26 11:54:09 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Overhaul-how-updates-compute-a-new-tuple.patch) at 2020-11-13 09:52:34 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (cleanup-modifytablepath.patch) at 2020-11-11 12:10:56 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: Yes)
    Attachment (v5-0001-Overhaul-how-updates-compute-a-new-tuple.patch) at 2020-10-29 13:03:33 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Overhaul-how-updates-compute-a-new-tuple.patch) at 2020-10-04 02:44:03 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v3-0002-Include-result-relation-index-if-any-in-ForeignSc.patch) at 2020-09-11 10:20:56 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Overhaul-UPDATE-s-targetlist-processing.patch) at 2020-06-12 06:46:41 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Overhaul-UPDATE-s-targetlist-processing.patch) at 2020-06-02 04:15:24 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
History
When Who What
2021-03-31 16:01:54 Tom Lane (tgl) Closed in commitfest 2021-03 with status: Committed
2021-03-31 16:01:54 Tom Lane (tgl) Changed committer to tgl
2021-02-01 12:33:59 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Moved to next CF
2021-01-15 20:43:36 Tom Lane (tgl) Added tgl as reviewer
2020-12-01 11:01:07 Anastasia Lubennikova (lubennikovaav) Closed in commitfest 2020-11 with status: Moved to next CF
2020-10-05 06:03:40 Amit Langote (amitlan) New status: Needs review
2020-10-01 04:32:30 Michael Paquier (michael-kun) New status: Waiting on Author
2020-10-01 04:32:26 Michael Paquier (michael-kun) Closed in commitfest 2020-09 with status: Moved to next CF
2020-08-01 20:57:14 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2020-07 with status: Moved to next CF
2020-06-14 13:55:40 Amit Langote (amitlan) Changed name to Overhaul UPDATE/DELETE processing
2020-06-02 04:20:47 Amit Langote (amitlan) Changed authors to Amit Langote (amitlan)
2020-06-02 04:20:47 Amit Langote (amitlan) Changed name to overhaul UPDATE targetlist processing
2020-06-02 04:19:12 Amit Langote (amitlan) Attached mail thread CA+HiwqHpHdqdDn48yCEhynnniahH78rwcrv1rEX65-fsZGBOLQ@mail.gmail.com
2020-06-02 04:19:11 Amit Langote (amitlan) Created patch record
Edit