Optimizing NULL check on pkey column

Title

Topic

Performance

Created

2020-08-27 15:57:28

Last modified

2020-12-01 11:04:50 (1 month, 2 weeks ago)

Latest email

2020-11-24 07:47:25 (1 month, 3 weeks ago)

Status

2021-01: Needs review

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 2020-11-24 07:47:25 by Surafel Temesgen <surafel3000 at gmail.com>
Latest attachment (null_check_on_pkey_optimization_v2.patch) at 2020-09-10 09:55:04 from Surafel Temesgen <surafel3000 at gmail.com>
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
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