Examine simple variable for Var in CTE.

4510

Title

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 (9 months, 3 weeks 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