Oct 2021

3 commits
Improve contrib/amcheck's tests for CREATE INDEX CONCURRENTLY.
28 Oct 2021Tom Lanemaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14.1REL_13_STABLE13.5+1 more
LLM analysis, 100% suremodified before commitlight changesfrom patchset #872 of 2 reviewers saw the final version

The commit retains both advisory-lock test rewrites and the REINDEX workload from #87. Tom additionally halves the ordinary-test transaction count, removes an obsolete comment, and deletes the unused background_pgbench() helper; the commit credits both Tom and sender Andrey.

  • Noah Mischsaw the final versionLLM analysis, 97% sureIn #85, Noah tested the advisory-lock rewrite with the underlying fix removed, reported comparable failure sensitivity and runtime, and endorsed its readability; subsequent changes extended the same test pattern.
  • Tom Lanesaw the final versioncommittercommitted the patch
Avoid race in RelationBuildDesc() affecting CREATE INDEX CONCURRENTLY.
24 Oct 2021Noah Mischmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14.1REL_13_STABLE13.5+4 more
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #670 of 1 reviewer saw the final version

Takes the relcache patch and its test infrastructure from #67, with matching backend changes in relcache.c and inval.c. Final edits replace concurrent reindexing in the test, remove sleeps, and capture background pgbench stderr, as explained in #70.

  • Andres Freundsaw an earlier versionLLM analysis, 98% sureThe commit explicitly credits Andres's review of earlier versions, corresponding to the series review in #53, before Noah's relcache hardening in #67.
Fix CREATE INDEX CONCURRENTLY for the newest prepared transactions.
24 Oct 2021Noah Mischmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14.1REL_13_STABLE13.5+4 more
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #671 of 3 reviewers saw the final version

Takes the prepared-transaction patch from the two-patch submission #67, retaining its backend changes in twophase.c, xact.c, lock.c, lmgr.c, and inval.c. Differences are test adjustments replacing REINDEX CONCURRENTLY with CREATE/DROP INDEX CONCURRENTLY, as discussed in #68.

  • Andres Freundsaw an earlier versionLLM analysis, 100% sureAndres challenged allocation under TwoPhaseStateLock, custom lists, comments, and unnecessary lookup costs in #53 and #61, and the commit explicitly credits his earlier review.
  • Peter Geoghegansaw an earlier versionLLM analysis, 83% surePeter endorsed using amcheck directly for robust regression coverage in #34, a testing recommendation adopted in #35 before substantial implementation revisions.
  • Noah Mischsaw the final versioncommittercommitted the patch

Jan 2021

1 commit
Fix CREATE INDEX CONCURRENTLY for simultaneous prepared transactions.
30 Jan 2021Noah Mischmaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1REL_13_STABLE13.2+5 more
LLM analysis, 100% surelanded as postedfrom patchset #171 of 3 reviewers saw the final version

All added and removed lines match #17, including lock-manager changes, VXID definitions, isolation tests, and documentation. Noah forwarded his final revision of Andrey's patch, whose authorship is explicitly credited in the commit.

  • Tom Lanesaw an earlier versionLLM analysis, 100% sureTom identified broken wait-flag semantics and questioned caller requirements in #5, before later validity-predicate and allocation corrections; the commit credits his earlier review.
  • Michael Paquiersaw an earlier versionLLM analysis, 100% sureMichael reviewed caller behavior and identified confusing and insufficient VXID validity checks in #8, before subsequent logic fixes; the commit credits his earlier review.
  • Noah Mischsaw the final versioncommittercommitted the patch

Credits across 4 commits

Author
Andrey BorodinLLM3
Noah MischLLM1
Reviewer
Noah Mischcommitter2
Tom Lanecommitter1
Committer
Noah Misch3
Tom Lane1

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