Mar 2020

2 commits
Avoid calls to RelationGetRelationName() and RelationGetNamespace() in vacuum code.
31 Mar 2020Amit Kapilamaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #1341 of 1 reviewer saw the final version

The commit exactly matches the cached-name component of #134 in src/backend/access/heap/vacuumlazy.c, also posted alone in #133. The accompanying reltuples cleanup was explicitly deferred in #135.

  • Amit Kapilasaw the final versiontrailerReviewed the cleanup in #133, discussed the cached index name and namespace lookup in #135, and committed the final version.
Introduce vacuum errcontext to display additional information.
30 Mar 2020Amit Kapilamaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1
LLM analysis, 100% surelanded as postedfrom patchset #1291 of 4 reviewers saw the final version

The diff matches #129 in src/backend/access/heap/vacuumlazy.c and src/tools/pgindent/typedefs.list without substantive changes. The commit explicitly credits Justin Pryzby, with changes by sender and committer Amit Kapila.

  • Alvaro Herrerasaw an earlier versiontrailerReviewed initialization, callback architecture, memory handling, phase enums, and naming through #115, after which #129 still changed truncation placement and index-cleanup restoration logic.
  • Amit Kapilasaw the final versiontrailerReviewed phase transitions, supplied revised patches, tested injected errors including parallel workers in #85, and committed his final attachment #129.
  • Andres Freundsaw an earlier versiontrailerIdentified misleading nested-operation context in #6, proposed LVRelStats in #24, and defended index context in #34 and #35 before subsequent architectural changes.
  • Michael Paquiersaw an earlier versiontrailerRequested schema-qualified operation messages in #3 and reviewed the expanded series in #8, before the later callback-state redesigns.

Dec 2019

2 commits
Refactor code dedicated to index vacuuming in vacuumlazy.c
26 Dec 2019Michael Paquiermaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1
LLM analysis, 100% surelanded as postedfrom patchset #150 of 1 reviewer saw the final version

The committed refactoring matches #15, extracting lazy_vacuum_all_indexes and moving heap progress reporting into lazy_vacuum_heap. The commit credits Justin Pryzby and sender Michael Paquier as co-authors.

  • Kyotaro Horiguchisaw an earlier versionLLM analysis, 87% sureIdentified the helper name's ambiguity and proposed an explicit conjunction in #13, adopted in #14 before #15 separated heap and index responsibilities.
Remove duplicated progress reporting during heap scan of VACUUM
15 Dec 2019Michael Paquiermaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #91 of 1 reviewer saw the final version

Takes only the redundant PROGRESS_VACUUM_PHASE update removal from the five-patch series #9. The commit preserves the adjacent 'Remove tuples from heap' comment that the attachment also deleted.

  • Michael Paquiersaw the final versioncommittercommitted the patch

Credits across 4 commits

Author
Justin Pryzby4
Michael Paquier1
with few changes by Amit Kapila1
Reviewer
Amit Kapila2
Michael Paquiercommitter2
Alvaro Herrera1
Andres Freund1
Committer
Amit Kapila2
Michael Paquier2