Mar 2024

1 commit
Avoid edge case in pg_visibility test with small shared_buffers
26 Mar 2024Andres Freundmaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1REL_16_STABLE16.3Also in: Sync scan & regression tests (landed as posted)

Oct 2023

1 commit
Fix bulk table extension when copying into multiple partitions
14 Oct 2023Andres Freundmaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1REL_16_STABLE16.1Also in: BUG #18130: \copy fails with "could not read block" or "page should be empty but not" errors due to triggers (not this thread)
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #53

The commit takes the first patch from #53, including the ReleaseBulkInsertStatePin() resets and COPY regression test, with only comment wording changes. It omits the separate ReadBufferBI() assertion patch, and #54 confirms the push.

Jul - Aug 2023

3 commits
hio: Take number of prior relation extensions into account
14 Aug 2023Andres Freundmaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1REL_16_STABLE16rc1
LLM analysis, 100% surelanded as postedfrom patchset #421 of 1 reviewer saw the final version

The three-file diff exactly matches #42, including the expanded comments and already_extended_by accounting. Checkout ancestry confirms this is the development-branch commit, while d37ab378b6 is its stable-branch counterpart.

  • Masahiko Sawadasaw the final versionLLM analysis, 100% sureMasahiko benchmarked #40 across client counts and reported substantial improvements in #41; only comments changed afterward.
Fix performance regression in pg_strtointNN_safe functions
2 Aug 2023David Rowleymaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1REL_16_STABLE16beta3
LLM analysis, 100% suremodified before commitlight changesfrom patchset #341 of 2 reviewers saw the final version

The executable numutils.c changes match #34; the commit expands function-header documentation and reflows comments, as confirmed in #36. Its author credit names Andres Freund alongside sender David Rowley, reflecting Andres's fast-path prototype #24.

  • Dean Rasheedsaw the final versiontrailerDean challenged early performance results, found the sign-only input bug in #33, and benchmarked and endorsed the final patch in #35.
  • John Naylorsaw an earlier versiontrailerJohn benchmarked both fast-path alternatives in #29, before the additional integer widths, first-digit optimization, and sign-only input correction.
Fix performance problem with new COPY DEFAULT code
27 Jul 2023David Rowleymaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1REL_16_STABLE16beta3
LLM analysis, 100% suremodified before commitlight changesfrom patchset #163 of 3 reviewers saw the final version

The commit preserves #16's allocation-once and reset-per-row implementation, but moves the allocation farther down BeginCopyFrom(). David explicitly identifies that placement adjustment as his only change in #27.

  • Dean Rasheedsaw the final versionLLM analysis, 100% sureDean tested #16 independently and alongside the numeric patch, reporting a clear speedup in #18.
  • Andres Freundsaw the final versionLLM analysis, 99% sureAndres used #16 in his benchmarks and explicitly supported committing it in #24.
  • David Rowleysaw the final versioncommittercommitted the patch

Credits across 5 commits

Author
Andres Freund1 LLM3
David Rowley1
Heikki Linnakangas1
Masahiko Sawada1
Reviewer
Andres Freundcommitter1
David Rowleycommitter1
Dean Rasheed1
John Naylor1
Reported by
Masahiko Sawada3
lights go out1
Committer
Andres Freund3
David Rowley2

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