Examine simple variable for Var in CTE.

Edit
ID 4510
Title Examine simple variable for Var in CTE.
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Server Features
Tags
Created 2023-08-21 08:22:38
Last modified 2023-11-17 19:37:28 (1 year ago)
Latest email 2024-01-29 02:30:52 (1 year ago)
Status
2023-11 (2023-11-01 – 2023-12-04): Committed
2023-09 (2023-09-01 – 2023-09-30): Moved to different 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 2024-01-29 02:30:52 by Richard Guo <guofenglinux at gmail.com>
Latest attachment (fix-examine-variable-for-INSERT-RETURNING.patch) at 2024-01-06 22:41:14 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (fix-examine-variable-for-INSERT-RETURNING.patch) at 2024-01-06 22:41:14 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    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
Edit