Ignore is not null quals on not null columns

Title

Topic

Performance

Created

2023-07-26 01:54:59

Last modified

2023-07-26 01:55:30 (2 months ago)

Latest email

2023-09-28 03:51:38 (2 days, 14 hours ago)

Status

2023-09: Needs review

Target version

Authors

David Rowley (davidrowley), Richard Guo (richardguo)

Reviewers

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-09-28 03:51:38 by David Rowley <dgrowleyml at gmail.com>
Latest attachment (v4_transform_NullTest_quals.patch) at 2023-09-26 13:42:32 from David Rowley <dgrowleyml at gmail.com>
    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-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