Ignore is not null quals on not null columns

Edit
ID 4459
Title Ignore is not null quals on not null columns
Topic Performance
Created 2023-07-26 01:54:59
Last modified 2024-01-23 05:47:24 (9 months, 2 weeks ago)
Latest email 2024-01-23 06:16:11 (9 months, 2 weeks ago)
Status
2024-01: Committed
2023-11: Moved to next CF
2023-09: Moved to next CF
Target version
Authors David Rowley (davidrowley), Richard Guo (richardguo)
Reviewers Become reviewer
Committer David Rowley (davidrowley)
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/4459
git checkout commitfest/cf/4459
Emails
BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower
First at 2022-07-05 22:13:15 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2024-01-23 06:16:11 by Richard Guo <guofenglinux at gmail.com>
Latest attachment (v11-0001-Reduce-NullTest-quals-to-constant-TRUE-or-FALSE.patch) at 2024-01-22 11:11:29 from David Rowley <dgrowleyml at gmail.com>
    Attachment (v11-0001-Reduce-NullTest-quals-to-constant-TRUE-or-FALSE.patch) at 2024-01-22 11:11:29 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Reduce-NullTest-quals-to-constant-TRUE-or-FALSE.patch) at 2023-12-07 11:04:37 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Reduce-NullTest-quals-to-constant-TRUE-or-FALSE.patch) at 2023-12-01 10:07:03 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Ignore-redundant-NOT-NULL-clauses.patch) at 2023-11-29 00:48:10 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Reduce-NullTest-quals-to-constant-TRUE-or-FALSE.patch) at 2023-11-01 02:20:49 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Reduce-NullTest-quals-to-constant-TRUE-or-FALSE.patch) at 2023-10-24 04:25:12 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (v5-0001-Reduce-NullTest-quals-to-constant-TRUE-or-FALSE.patch) at 2023-10-08 08:26:43 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v4_transform_NullTest_quals.patch) at 2023-09-26 13:42:32 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v4-0001-ignore-is-not-null-quals-on-not-null-columns.patch) at 2023-07-26 03:17:44 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v3-0001-ignore-is-not-null-quals-on-not-null-columns.patch) at 2023-07-10 06:39:27 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v2-0001-ignore-is-not-null-quals-on-not-null-columns.patch) at 2023-07-07 07:02:59 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (ignore_is_not_null_base_quals_on_not_null_columns.patch) at 2023-07-05 23:55:36 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Track-NOT-NULL-columns-in-RelOptInfo-for-base-rel.patch) at 2022-07-07 03:31:30 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
History
When Who What
2024-01-23 05:47:24 David Rowley (davidrowley) Closed in commitfest 2024-01 with status: Committed
2024-01-23 05:47:24 David Rowley (davidrowley) Changed committer to davidrowley
2023-12-04 09:47:49 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 09:47:18 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-07-26 01:55:30 Richard Guo (richardguo) Changed authors to David Rowley (davidrowley), Richard Guo (richardguo)
2023-07-26 01:55:00 Richard Guo (richardguo) Attached mail thread 17540-7aa1855ad5ec18b4@postgresql.org
2023-07-26 01:54:59 Richard Guo (richardguo) Created patch record
Edit