Ignore is not null quals on not null columns

Edit
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 (2 months, 3 weeks ago)
Latest email 2024-01-23 06:16:11 (2 months, 3 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
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