Sep 2024

1 commit
Remember last collation to speed up collation cache.
3 Sep 2024Jeff Davismaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1Also in: tiny step toward threading: reduce dependence on setlocale() (not this thread)
LLM analysis, 99% suremodified before commitlight changesfrom patchset #51 of 1 reviewer saw the final version

The commit preserves the last-collation check and cache updates from #5 in src/backend/utils/adt/pg_locale.c, with only variable renaming, declaration relocation, an explanatory comment, and reversed equality operands. The current verdict for thread #49738 confirms that its attachments contain no matching optimization and attributes this change to #5, so its later patchsets do not supersede this source.

  • Jeff Davissaw the final versioncommittercommitted the patch

Jul 2024

1 commit
Change collation cache to use simplehash.h.
28 Jul 2024Jeff Davismaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1
LLM analysis, 100% surelanded as postedfrom patchset #41 of 2 reviewers saw the final version

All added and removed lines match #4, including murmurhash32, the 16-entry initial allocation, and collation_cache_insert(). Differences in src/backend/utils/adt/pg_locale.c are surrounding base context, consistent with landing independently of the accompanying refactoring.

  • John Naylorsaw an earlier versiontrailerJohn recommended the inline murmurhash32 function in #3 after reviewing #1; the subsequent revision changed the hash function and initial table size.
  • Andreas Karlssonsaw the final versiontrailerAndreas benchmarked #4, reported reduced lookup overhead, and explicitly judged the simplehash patch ready for commit in #5.

Credits across 2 commits

Author
Andreas KarlssonLLM1
Jeff DavisLLM1
Reviewer
Andreas Karlsson1
Jeff Daviscommitter1
John Naylor1
Committer
Jeff Davis2

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