Jul 2021

1 commit
Use a hash table to speed up NOT IN(values)
7 Jul 2021David Rowleymaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #771 of 2 reviewers saw the final version

The commit matches #77 except for renaming the executor state member useOr to inclause, a comment punctuation edit, and a src/include/catalog/catversion.h bump; its regression changes are identical. David Rowley confirms these minor final adjustments in #78, and the commit credits him and James Coleman as authors.

  • James Colemansaw an earlier versiontrailerColeman reviewed the NOT IN implementation and questioned naming and unsupported operator cases in #67 and #71, before the separate negfuncid representation was introduced in #73.
  • Zhihong Yusaw the final versiontrailerYu identified the copied dependency-function argument in #74, which was corrected in #76, with only small cleanup, naming, and assertion changes afterward.

Apr 2021

1 commit
Speedup ScalarArrayOpExpr evaluation
8 Apr 2021David Rowleymaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #482 of 3 reviewers saw the final version

The commit preserves the implementation and tests in #48, with comment and formatting cleanup, harmless declaration/assignment rearrangement, and a src/include/catalog/catversion.h bump. The commit credits James Coleman and David Rowley, whose posting #50 confirms committing the final patch with minor cleanup.

  • David Rowleysaw the final versiontrailerRowley reviewed thresholds in #5, benchmarked and redesigned the implementation in #45 and #48, tested it in #49, and reviewed the final version as committer.
  • Tomas Vondrasaw the final versiontrailerVondra supplied benchmarks and design feedback throughout, including comparisons of #44 and #45 in #47 and explicit testing of the final patch #48 reported after the commit in #55.
  • Heikki Linnakangassaw an earlier versiontrailerLinnakangas said the simplehash implementation looked good and proposed broader array handling in #40 and #42, before the substantial planner-controlled redesign.

Credits across 2 commits

Author
David Rowley2
James Coleman2
Reviewer
David Rowley1
Heikki Linnakangas1
James Coleman1
Tomas Vondra1
Zhihong Yu1
Committer
David Rowley2