Mar 2020

4 commits
Prevent functional dependency estimates from exceeding column estimates.
28 Mar 2020Dean Rasheedmaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1Also in: Additional improvements to extended statistics (not this thread)
LLM analysis, 100% suremodified before commitlight changesfrom patchset #191 of 1 reviewer saw the final version

Matches #19, with deps_clauselist_selectivity renamed to clauselist_apply_dependencies and light comment/formatting edits; the regression changes are identical. The prototype originated in thread #41787, whose recorded verdict likewise identifies this thread’s later submission as the canonical source.

  • Tomas Vondrasaw the final versionLLM analysis, 100% sureRequested helper extraction and clearer formula explanations in #17, then reviewed the revision and proposed the adopted helper name in #20; the commit also explicitly credits his review.
Recognize some OR clauses as compatible with functional dependencies
18 Mar 2020Tomas Vondramaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1
LLM analysis, 100% surelanded as postedfrom patchset #121 of 1 reviewer saw the final version

The normalized diff exactly matches #12 across dependencies.c and both stats_ext regression files, including recursive same-attribute OR recognition.

  • Dean Rasheedsaw the final versiontrailerReviewed the OR-recognition patch in #13 and argued that changing the underlying single-column OR estimates was outside its scope.
Use multi-variate MCV lists to estimate ScalarArrayOpExpr
14 Mar 2020Tomas Vondramaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #51 of 1 reviewer saw the final version

Exactly matches the fifth patch of #5 modulo diff metadata and whitespace, adding ScalarArrayOpExpr support in extended_stats.c and mcv.c with tests. The series’ functional-dependency patches landed separately.

  • Dean Rasheedsaw the final versionLLM analysis, 99% sureExplicitly credited by the commit’s 'Review: Dean Rasheed' line; #6 identifies his participation, but the supplied discussion does not show an MCV-specific review.
Use functional dependencies to estimate ScalarArrayOpExpr
14 Mar 2020Tomas Vondramaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #52 of 2 reviewers saw the final version

Combines the first four patches of #5: applying them produces byte-identical dependencies.c and regression files, with the commit additionally documenting IN support in doc/src/sgml/perform.sgml. The commit credits Pierre Ducroquet, whose original implementation appears in #1.

  • Tomas Vondrasaw the final versiontrailerExamined the original implementation in #2 and #4, supplied argument-handling fixes and tests in #5, and committed the final version.
  • Dean Rasheedsaw the final versiontrailerAnalyzed the expanded IN support’s clause-compatibility and estimation limitations in #6 and #8, supporting the restricted PG13 scope before commitment.

Credits across 4 commits

Author
Tomas Vondra2
Dean RasheedLLM1
Pierre Ducroquet1
Reviewer
Dean Rasheed2
Tomas Vondra1
Committer
Tomas Vondra3
Dean Rasheed1

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