Ignore is not null quals on not null columns

Title

Topic

Performance

Created

2023-07-26 01:54:59

Last modified

2024-01-23 05:47:24 (3 months ago)

Latest email

2024-01-23 06:16:11 (3 months 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