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

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v1, Patch count: 1, First patch: +17−5, All patches: +17−5

Topic

Performance

Tags

Created

2025-06-07 01:38:28

Last modified

2025-08-01 18:54:51 (2 weeks ago)

Latest email

2025-07-18 21:54:05 (4 weeks ago)

Status

PG19-2 (2025-09-01 - 2025-09-30): Needs review

PG19-1 (2025-07-01 - 2025-07-31): Moved to different CF

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-07-18 21:54:05 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v1-0001-Track-the-maximum-possible-frequency-of-non-MCE-a.patch) at 2025-07-18 21:54:05 from Tom Lane <tgl at sss.pgh.pa.us>
Attachment (v1-0001-Track-the-maximum-possible-frequency-of-non-MCE-a.patch) at 2025-07-18 21:54:05 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
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-08-01 18:54:51	Tom Lane (tgl)	Moved from CF PG19-1 to CF PG19-2
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