Examine simple variable for Var in CTE.

Edit
ID 4510
Title Examine simple variable for Var in CTE.
Topic Server Features
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 (10 months, 1 week 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 CFbot results (CirrusCI) CFbot GitHub
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/4510
git checkout commitfest/cf/4510
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