Improve array-element-test estimation when no array elements qualify as common

Edit

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch count: 1, First patch: +18−2, All patches: +18−2

Topic

Performance

Created

2025-06-07 01:38:28

Last modified

2025-06-07 01:39:47 (4 days ago)

Latest email

2025-06-07 01:29:54 (4 days ago)

Status

2025-07: Needs review

Target version

Authors

Tom Lane (tgl)

Reviewers

Committer

Links

Emails

Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column: First at 2025-06-05 15:42:00 by Mark Frost <FROSTMAR at uk.ibm.com>
Latest at 2025-06-07 01:29:54 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (wip-always-record-minimum-MCE-frequency.patch) at 2025-06-07 01:29:54 from Tom Lane <tgl at sss.pgh.pa.us>
Attachment (wip-always-record-minimum-MCE-frequency.patch) at 2025-06-07 01:29:54 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)

History

When	Who	What
2025-06-07 01:39:47	Tom Lane (tgl)	Changed name to Improve array-element-test estimation when no array elements qualify as common
2025-06-07 01:38:28	Tom Lane (tgl)	Attached mail thread PH3PPF1C905D6E6F24A5C1A1A1D8345B593E16FA@PH3PPF1C905D6E6.namprd15.prod.outlook.com
2025-06-07 01:38:28	Tom Lane (tgl)	Created patch record

Edit