Propagate pathkeys from CTEs up to the outer query

Title

Topic

Performance

Created

2023-11-20 03:08:38

Last modified

2023-11-20 03:08:53 (2 weeks ago)

Latest email

2023-11-21 06:18:19 (1 week, 5 days ago)

Status

2024-01: Needs review

Target version

Authors

Richard Guo (richardguo)

Reviewers

Committer

Links

Emails

Wrong rows estimations with joins of CTEs slows queries by more than factor 500: First at 2023-02-08 13:55:07 by Hans Buschmann <buschmann at nidsa.net>
Latest at 2023-11-21 06:18:19 by Richard Guo <guofenglinux at gmail.com>
Latest attachment (v2-0001-Propagate-pathkeys-from-CTEs-up-to-the-outer-query.patch) at 2023-11-21 06:18:19 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v2-0001-Propagate-pathkeys-from-CTEs-up-to-the-outer-query.patch) at 2023-11-21 06:18:19 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Propagate-pathkeys-from-CTEs-up-to-the-outer-query.patch) at 2023-11-20 02:42:31 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Examine-simple-variable-for-Var-in-CTE.patch) at 2023-11-08 22:44:55 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (src_backend_utils_adt_selfuncs.c.gcov.html.png) at 2023-09-06 06:00:39 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (0001-Examine-simple-variable-for-Var-in-CTE.patch) at 2023-08-21 08:16:12 from Jian Guo <gjian at vmware.com> (Patch: Yes)
    Attachment (0001-Add-stats-info-for-Vars-in-CTEs.patch) at 2023-08-14 11:12:07 from Jian Guo <gjian at vmware.com> (Patch: Yes)
    Attachment (query-complete.sql) at 2023-02-09 15:53:08 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)

History

When	Who	What
2023-11-20 03:08:52	Richard Guo (richardguo)	Changed authors to Richard Guo (richardguo)
2023-11-20 03:08:39	Richard Guo (richardguo)	Attached mail thread 4504e67078d648cdac3651b2960da6e7@nidsa.net
2023-11-20 03:08:38	Richard Guo (richardguo)	Created patch record