Examine simple variable for Var in CTE.

Title

Topic

Server Features

Created

2023-08-21 08:22:38

Last modified

2023-11-17 19:37:28 (2 weeks, 2 days ago)

Latest email

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

Status

2023-11: Committed

2023-09: Moved to next CF

Target version

Authors

Jian Guo (aegeaner)

Reviewers

Tom Lane (tgl), Richard Guo (richardguo)Become reviewer

Committer

Tom Lane (tgl)

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-17 19:37:28	Tom Lane (tgl)	Closed in commitfest 2023-11 with status: Committed
2023-11-17 19:37:28	Tom Lane (tgl)	Changed committer to tgl
2023-11-17 02:20:24	Richard Guo (richardguo)	Added richardguo as reviewer
2023-11-08 22:45:27	Tom Lane (tgl)	Added tgl as reviewer
2023-10-02 09:59:45	Peter Eisentraut (petere)	Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-21 08:23:13	Jian Guo (aegeaner)	Changed authors to Jian Guo (aegeaner)
2023-08-21 08:22:38	Jian Guo (aegeaner)	Attached mail thread 4504e67078d648cdac3651b2960da6e7@nidsa.net
2023-08-21 08:22:38	Jian Guo (aegeaner)	Created patch record