Overhaul UPDATE/DELETE processing

Title

Topic

Performance

Created

2020-06-02 04:19:11

Last modified

2021-03-31 16:01:54 (2 years ago)

Latest email

2021-04-02 07:41:13 (2 years 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