Overhaul UPDATE/DELETE processing

Edit
Title Overhaul UPDATE/DELETE processing
Topic Performance
Created 2020-06-02 04:19:11
Last modified 2021-03-31 16:01:54 (2 years, 12 months ago)
Latest email 2021-04-02 07:41:13 (2 years, 12 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
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