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, 7 months ago)

Latest email 2021-04-02 07:41:13 (3 years, 7 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