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

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v2, Patch count: 1, First patch: +67−30, All patches: +67−30

Topic

Performance

Tags

Created

2025-06-07 01:38:28

Last modified

2025-09-20 18:48:48 (1 month ago)

Latest email

2025-09-19 19:23:22 (1 month ago)

Status

PG19-2 (2025-09-01 – 2025-09-30): Committed

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

Target version

Authors

Tom Lane (tgl)

Reviewers

Committer

Tom Lane (tgl)

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-09-19 19:23:22 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v2-0001-Track-the-maximum-possible-frequency-of-non-MCE-a.patch) at 2025-09-08 23:37:01 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (v2-0001-Track-the-maximum-possible-frequency-of-non-MCE-a.patch) at 2025-09-08 23:37:01 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    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-09-20 18:48:48	Tom Lane (tgl)	Closed in commitfest PG19-2 with status: Committed
2025-09-20 18:48:48	Tom Lane (tgl)	Changed committer to tgl
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