Nov 2022

3 commits
Use multi-inserts for pg_ts_config_map
16 Nov 2022Michael Paquiermaster16beta1REL_19_STABLE16beta1REL_18_STABLE16beta1REL_17_STABLE16beta1REL_16_STABLE16beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #90 of 1 reviewer saw the final version

This commit extracts the tsearchcmds.c portion of #9, preserving its batched inserts and shared index state for updates with only whitespace changes. The commit credits Michael Paquier and Ranier Vilela as authors.

  • Kyotaro Horiguchisaw an earlier versiontrailerKyotaro supported the original cleanup and suggested multi-inserts in #2, before the substantial tuple-slot implementation in #9.
Use multi-inserts for pg_enum
16 Nov 2022Michael Paquiermaster16beta1REL_19_STABLE16beta1REL_18_STABLE16beta1REL_17_STABLE16beta1REL_16_STABLE16beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #91 of 2 reviewers saw the final version

This commit extracts EnumValuesCreate() batching in src/backend/catalog/pg_enum.c from #9. Its only substantive textual adjustment is using the equivalent Name typedef instead of NameData * for enumlabel.

  • Kyotaro Horiguchisaw an earlier versiontrailerKyotaro proposed multi-inserts while reviewing the original patch in #2, but no review of the subsequently implemented batching in #9 appears.
  • Ranier Vilelasaw the final versiontrailerRanier accepted Michael's revised approach as making sense in #10, after the enum batching implementation appeared in #9.
Avoid some overhead with open and close of catalog indexes
16 Nov 2022Michael Paquiermaster16beta1REL_19_STABLE16beta1REL_18_STABLE16beta1REL_17_STABLE16beta1REL_16_STABLE16beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #91 of 2 reviewers saw the final version

The heap.c and analyze.c changes match their portions of #9 exactly, retaining lazy index opening and WithInfo calls while excluding the batching work. The commit explicitly credits Ranier Vilela, who submitted the original implementation in #1.

  • Kyotaro Horiguchisaw an earlier versiontrailerKyotaro reviewed the original unconditional index-opening approach in #2, before #9 changed the logic to avoid opening indexes when no tuples require writing.
  • Michael Paquiersaw the final versiontrailerMichael benchmarked the original patch in #6, supplied the lazy-opening revision in #9, and committed the final version as confirmed in #12.

Credits across 3 commits

Author
Michael Paquier2
Ranier Vilela2
Reviewer
Kyotaro Horiguchi3
Michael Paquier1
Ranier Vilela1
Reported by
Ranier Vilela1
Committer
Michael Paquier3