Ignore is not null quals on not null columns

Title

Topic

Performance

Created

2023-07-26 01:54:59

Last modified

2023-10-02 09:47:18 (1 month, 4 weeks ago)

Latest email

2023-11-29 00:48:10 (2 days, 2 hours ago)

Status

2023-11: Needs review

2023-09: Moved to next CF

Target version

Authors

David Rowley (davidrowley), Richard Guo (richardguo)

Reviewers

Become reviewer

Committer

Links

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 2023-11-29 00:48:10 by David Rowley <dgrowleyml at gmail.com>
Latest attachment (v8-0001-Ignore-redundant-NOT-NULL-clauses.patch) at 2023-11-29 00:48:10 from David Rowley <dgrowleyml at gmail.com>
    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
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