Improve rowcount estimate for UNNEST(column)

Title

Topic

Performance

Created

2023-11-25 17:21:17

Last modified

2024-01-04 23:45:37 (10 months, 2 weeks ago)

Latest email

2024-01-04 23:45:07 (10 months, 2 weeks ago)

Status

2024-01: Committed

Target version

Authors

Paul Jungwirth (pjungwir)

Reviewers

Committer

Tom Lane (tgl)

Links

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4672
git checkout commitfest/cf/4672

Emails

Improve rowcount estimate for UNNEST(column): First at 2023-11-25 17:19:45 by Paul A Jungwirth <pj at illuminatedcomputing.com>
Latest at 2024-01-04 23:45:07 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v2-0001-Use-statitics-for-estimating-UNNEST-column-rows.patch) at 2023-12-07 06:32:07 from Paul Jungwirth <pj at illuminatedcomputing.com>
    Attachment (v2-0001-Use-statitics-for-estimating-UNNEST-column-rows.patch) at 2023-12-07 06:32:07 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v1-0001-minor-refactor.patch) at 2023-11-30 04:35:14 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Use-statitics-for-estimating-UNNEST-column-rows.patch) at 2023-11-25 17:19:45 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)

History

When	Who	What
2024-01-04 23:45:37	Tom Lane (tgl)	Closed in commitfest 2024-01 with status: Committed
2024-01-04 23:45:37	Tom Lane (tgl)	Changed committer to tgl
2024-01-04 22:06:17	Tom Lane (tgl)	Added tgl as reviewer
2023-11-25 17:21:33	Paul Jungwirth (pjungwir)	Changed authors to Paul Jungwirth (pjungwir)
2023-11-25 17:21:18	Paul Jungwirth (pjungwir)	Attached mail thread CA+renyUnM2d+SmrxKpDuAdpiq6FOM=FByvi6aS6yi__qyf6j9A@mail.gmail.com
2023-11-25 17:21:17	Paul Jungwirth (pjungwir)	Created patch record