Apr 2019

1 commit
Prevent inlining of multiply-referenced CTEs with outer recursive refs.
9 Apr 2019Tom Lanemaster12beta1REL_19_STABLE12beta1REL_18_STABLE12beta1REL_17_STABLE12beta1REL_16_STABLE12beta1REL_15_STABLE12beta1REL_14_STABLE12beta1REL_13_STABLE12beta1+1 more
LLM analysis, 100% surewritten from the discussion, no matching patch

Implements the recursive-reference restriction proposed in #107, adding contain_outer_selfref in src/backend/optimizer/plan/subselect.c and regression tests for multiple worktable references. No attached patch contains this fix, and Tom Lane confirms implementing it in #113.

Feb 2019

1 commit
Allow user control of CTE materialization, and change the default behavior.
16 Feb 2019Tom Lanemaster12beta1REL_19_STABLE12beta1REL_18_STABLE12beta1REL_17_STABLE12beta1REL_16_STABLE12beta1REL_15_STABLE12beta1REL_14_STABLE12beta1REL_13_STABLE12beta1+1 more
LLM analysis, 94% suremodified before commitmoderate changesfrom patchset #881 of 4 reviewers saw the final version

Combines the planner implementation and revised optimization-fence documentation in #88 with the MATERIALIZED / NOT MATERIALIZED grammar, deparsing, and tests from #68, plus a catalog-version bump; #103 confirms the selected syntax. The commit credits Andreas Karlsson, Andrew Gierth, and David Fetter for the patch subsequently revised and posted by Tom Lane.

  • Thomas Munrosaw an earlier versionLLM analysis, 97% sureReported the postgres_fdw check-world failure in #22 and demonstrated parallel-query improvements in #25, before substantial traversal and materialization-policy revisions.
  • Robert Haassaw an earlier versionLLM analysis, 92% sureProposed extending the posted patch with explicit control in both directions in #48 and explained the multiply-referenced use case in #60, which was implemented in #68.
  • Andres Freundsaw an earlier versionLLM analysis, 85% sureProposed an explicit AS MATERIALIZED control in #9 and explained limitations of OFFSET-based control, with the syntax subsequently implemented in #28.
  • Tom Lanesaw the final versioncommittercommitted the patch

Jan 2019

1 commit
Split QTW_EXAMINE_RTES flag into QTW_EXAMINE_RTES_BEFORE/_AFTER.
25 Jan 2019Tom Lanemaster12beta1REL_19_STABLE12beta1REL_18_STABLE12beta1REL_17_STABLE12beta1REL_16_STABLE12beta1REL_15_STABLE12beta1REL_14_STABLE12beta1REL_13_STABLE12beta1+1 more
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #651 of 1 reviewer saw the final version

Extracts the query-walker portion of #65: nodeFuncs.c, nodeFuncs.h, setrefs.c, and rewriteManip.c gain BEFORE/AFTER visitation flags, with comment improvements and adjusted flag-bit assignments. Tom Lane explicitly reports this independent landing in #67, and the commit credits Andreas Karlsson, the source patchset's sender.

  • Tom Lanesaw the final versioncommittercommitted the patch

Credits across 3 commits

Author
Andreas KarlssonLLM2
Reviewer
Tom Lanecommitter2
Committer
Tom Lane3

N LLM means N of the credits come from LLM analysis, not from commit trailers.