Optimizing NULL check on pkey column

2699

Title

Topic

Performance

Created

2020-08-27 15:57:28

Last modified

2021-09-27 00:52:24 (3 years, 2 months ago)

Latest email

2021-09-27 00:52:09 (3 years, 2 months ago)

Status

2021-09: Returned with feedback

2021-07: Moved to next CF

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

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/2699
git checkout commitfest/cf/2699

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-09-27 00:52:09 by Jaime Casanova <jcasanov at systemguards.com.ec>
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-09-27 00:52:24	Jaime Casanova (jcasanov)	Closed in commitfest 2021-09 with status: Returned with feedback
2021-08-03 02:26:57	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-07 with status: Moved to next CF
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