Dec 2020

3 commits
Improve estimation of ANDs under ORs using extended statistics.
8 Dec 2020Dean Rasheedmaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% surelanded as postedfrom patchset #391 of 1 reviewer saw the final version

Matches the second patch in #39 by stable patch ID, including bare-AND handling in clausesel.c and extended_stats.c and the expected-output changes.

  • Tomas Vondrasaw the final versionLLM analysis, 100% sureThe commit explicitly credits Tomas Vondra as reviewer, corroborating his pre-commit response to both patches in #40.
Improve estimation of OR clauses using multiple extended statistics.
8 Dec 2020Dean Rasheedmaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #391 of 1 reviewer saw the final version

Matches the first patch in #39, with only wording changed in the comment explaining independence between statistics objects in extended_stats.c; executable changes and expected estimates are unchanged.

  • Tomas Vondrasaw the final versionLLM analysis, 100% sureThe commit explicitly credits Tomas Vondra as reviewer, corroborating his pre-commit response to both patches in #40.
Improve estimation of OR clauses using extended statistics.
3 Dec 2020Dean Rasheedmaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% surelanded as postedfrom patchset #361 of 1 reviewer saw the final version

Applying #36 to the commit's parent reproduces all nine committed files exactly after removing erroneous new-file metadata from the attachment. The commit credits the original patch to Tomas Vondra, with additional improvements by Dean Rasheed.

  • Dean Rasheedsaw the final versioncommittercommitted the patch

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: PATCH: add support for IN and @> in functional-dependency statistics use (modified before commit)
Fix wording of several extended stats comments
18 Mar 2020Tomas Vondramaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1
LLM analysis, 100% surewritten from the discussion, no matching patch

Adds the missing word 'has' to two existing extended_stats.c comments, implementing Thomas Munro's wording correction in #14 separately from the attached feature patches. The commit credits him as Reported-by.

Improve test coverage for multi-column MCV lists
14 Mar 2020Tomas Vondramaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1
LLM analysis, 100% surelanded as postedfrom patchset #12

Exactly matches the standalone MCV test-coverage patch in #12 by stable patch ID, changing stats_ext.sql and stats_ext.out.

Improve test coverage for functional dependencies
14 Mar 2020Tomas Vondramaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1
LLM analysis, 100% surelanded as postedfrom patchset #12

Exactly matches the standalone functional-dependency test patch in #12 by stable patch ID, adding reversed-operand queries and dependency-output coverage.

Credits across 7 commits

Author
Dean RasheedLLM3
Tomas Vondra1 LLM3
Reviewer
Dean Rasheedcommitter1
Reported by
Thomas Munro1
Committer
Dean Rasheed4
Tomas Vondra3

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