Examine simple variable for Var in CTE.

Title

Topic

Server Features

Created

2023-08-21 08:22:38

Last modified

2023-08-21 08:23:13 (1 month, 1 week ago)

Latest email

2023-09-07 09:26:41 (3 weeks, 2 days ago)

Status

2023-09: Needs review

Target version

Authors

Jian Guo (aegeaner)

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-09-07 09:26:41 by Jian Guo <gjian at vmware.com>
Latest 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>
    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-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