Feb 2020

3 commits
Teach pageinspect about nbtree deduplication.
29 Feb 2020Peter Geogheganmaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1
LLM analysis, 99% surepart of a posted patchsetmoderate changesfrom patchset #140

Takes the pageinspect component of #140, excluding the separate debug-value patch. Before landing, btreefuncs.c gained tuple-length validation and BlessTupleDesc calls, while pivot handling comments and doc/src/sgml/pageinspect.sgml examples were revised.

Doc: Fix deduplicate_items index term.
27 Feb 2020Peter Geogheganmaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1
LLM analysis, 100% surewritten from the discussion, no matching patch

The change to doc/src/sgml/ref/create_index.sgml exactly implements Fujii Masao's inline index-term correction in #142; Peter confirms the fix in #143. No attached patchset contains this follow-up correction.

Add deduplication to nbtree.
26 Feb 2020Peter Geogheganmaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1
LLM analysis, 99% surepart of a posted patchsetlight changesfrom patchset #1401 of 2 reviewers saw the final version

Takes the main deduplication component of #140, excluding its equalimage prerequisite, pageinspect component, and debug patch; final edits primarily revise documentation, diagnostics, header organization, and XLOG_PAGE_MAGIC. The commit explicitly credits Anastasia Lubennikova and Peter Geoghegan as co-authors, and #141 confirms landing.

  • Peter Geoghegansaw the final versiontrailerPeter reviewed invariants, exercised amcheck and WAL replay, supplied fixes and performance refinements throughout the thread, and reviewed the final version as committer, confirmed in #141.
  • Heikki Linnakangassaw an earlier versiontrailerHeikki questioned the tuple format in #39 and annotated #125 in #126, prompting substantial later changes to page deduplication, unique-index handling, and VACUUM WAL.

Dec 2019

1 commit
Remove unneeded "pin scan" nbtree VACUUM code.
19 Dec 2019Peter Geogheganmaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1
LLM analysis, 99% surepart of a posted patchsetlight changesfrom patchset #118

Takes the pin-scan removal prerequisite from #118, preserving its lastBlockVacuumed-to-ndeleted replacement and removal of unused VACUUM bookkeeping. Final additions principally update nbtree/README, explanatory comments, and XLOG_PAGE_MAGIC; #124 confirms landing and resubmits the remainder.

Credits across 4 commits

Author
Peter Geoghegan1 LLM3
Anastasia Lubennikova1
Reviewer
Heikki Linnakangas1
Peter Geoghegan1
Reported by
Fujii Masao1
Committer
Peter Geoghegan4

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