Optimizing NULL check on pkey column

Title

Topic

Performance

Created

2020-08-27 15:57:28

Last modified

2021-04-08 15:41:55 (4 days, 2 hours ago)

Latest email

2021-03-10 16:58:16 (1 month ago)

Status

2021-07: Needs review

2021-03: Moved to next CF

2021-01: Moved to next CF

2020-11: Moved to next CF

2020-09: Moved to next CF

Target version

Authors

Surafel Temesgen (surafel)

Reviewers

Ashutosh Bapat (ashutoshbapat)Become reviewer

Committer

Links

Emails

Evaluate expression at planning time for two more cases: First at 2020-08-27 12:31:15 by Surafel Temesgen <surafel3000 at gmail.com>
Latest at 2021-03-10 16:58:16 by Surafel Temesgen <surafel3000 at gmail.com>
Latest attachment (null_check_on_pkey_optimization_v3.patch) at 2021-03-08 16:12:52 from Ibrar Ahmed <ibrar.ahmad at gmail.com>
    Attachment (null_check_on_pkey_optimization_v3.patch) at 2021-03-08 16:12:52 from Ibrar Ahmed <ibrar.ahmad at gmail.com> (Patch: Yes)
    Attachment (null_check_on_pkey_optimization_v2.patch) at 2020-09-10 09:55:04 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (null_check_on_pkey_optimization_v1.patch) at 2020-08-27 12:31:15 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)

History

When	Who	What
2021-04-08 15:41:55	David Steele (dsteele)	Closed in commitfest 2021-03 with status: Moved to next CF
2021-02-01 12:36:28	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-01 with status: Moved to next CF
2020-12-01 11:04:50	Anastasia Lubennikova (lubennikovaav)	Closed in commitfest 2020-11 with status: Moved to next CF
2020-11-24 07:48:17	Surafel Temesgen (surafel)	New status: Needs review
2020-11-16 11:05:03	Pavel Borisov (pborisov)	Posted comment with messageid <160552470322.32482.1367621091798274540.pgcf@coridan.postgresql.org>
2020-11-16 11:05:03	Pavel Borisov (pborisov)	New status: Waiting on Author
2020-10-07 02:10:50	Takayuki Tsunakawa (maumau)	Removed maumau from reviewers
2020-10-07 02:09:44	Takayuki Tsunakawa (maumau)	Added maumau as reviewer
2020-10-01 04:28:25	Michael Paquier (michael-kun)	Closed in commitfest 2020-09 with status: Moved to next CF
2020-09-18 09:56:24	Ashutosh Bapat (ashutoshbapat)	Added ashutoshbapat as reviewer
2020-09-14 05:19:12	Surafel Temesgen (surafel)	New status: Needs review
2020-09-10 00:21:18	Tom Lane (tgl)	New status: Waiting on Author
2020-08-27 15:58:03	Surafel Temesgen (surafel)	Changed authors to Surafel Temesgen (surafel)
2020-08-27 15:57:28	Surafel Temesgen (surafel)	Attached mail thread CALAY4q_Wazcha2f0kpd=zVh7bwfC=txF_n2XVdvmRmGCS+pWeQ@mail.gmail.com
2020-08-27 15:57:28	Surafel Temesgen (surafel)	Created patch record