Jun 2021

1 commit
Remove forced toast recompression in VACUUM FULL/CLUSTER
14 Jun 2021Michael Paquiermaster14beta2REL_19_STABLE14beta2REL_18_STABLE14beta2REL_17_STABLE14beta2REL_16_STABLE14beta2REL_15_STABLE14beta2REL_14_STABLE14beta2
LLM analysis, 100% suremodified before commitlight changesfrom patchset #621 of 1 reviewer saw the final version

The heapam_handler.c removal and all regression changes match #62. The only substantive textual difference is retaining “However” in alter_table.sgml instead of the patch's “When”.

  • Alvaro Herrerasaw the final versionLLM analysis, 95% sureIn #63, he benchmarked an equivalent removal of the recompression code against unmodified master and his alternative inlining implementation.

May 2021

3 commits
Rethink definition of pg_attribute.attcompression.
27 May 2021Tom Lanemaster14beta2REL_19_STABLE14beta2REL_18_STABLE14beta2REL_17_STABLE14beta2REL_16_STABLE14beta2REL_15_STABLE14beta2REL_14_STABLE14beta2
LLM analysis, 100% suremodified before commitmoderate changesfrom patchset #270 of 1 reviewer saw the final version

Matches the consolidated semantics, grammar, documentation, and tests in #27, with additional pg_dump/psql ordering cleanup and a catalog-version bump. GetAttributeCompression() now uses TypeIsToastable(), accepting types with external default storage that the submitted IsStorageCompressible() check rejected.

  • Alvaro Herrerasaw an earlier versionLLM analysis, 99% sureIn #28, he reported testing partitioned-table behavior and checking LIKE behavior, before the committed version changed the datatype eligibility check.
Fix memory leak when de-toasting compressed values in VACUUM FULL/CLUSTER
25 May 2021Michael Paquiermaster14beta2REL_19_STABLE14beta2REL_18_STABLE14beta2REL_17_STABLE14beta2REL_16_STABLE14beta2REL_15_STABLE14beta2REL_14_STABLE14beta2
LLM analysis, 100% suremodified before commitmoderate changesfrom patchset #120 of 1 reviewer saw the final version

Implements the detoasted-value tracking and cleanup from #12, but eliminates its separate tup_values array and operates directly on values. Michael explains this simplification and the comment rearrangement in #19.

  • Dilip Kumarsaw an earlier versiontrailerHe reviewed the value-copying logic in #16 and #18, after which Michael removed the redundant array before committing.
Re-order pg_attribute columns to eliminate some padding space.
23 May 2021Tom Lanemaster14beta2REL_19_STABLE14beta2REL_18_STABLE14beta2REL_17_STABLE14beta2REL_16_STABLE14beta2REL_15_STABLE14beta2REL_14_STABLE14beta2
LLM analysis, 100% suremodified before commitmoderate changesfrom patchset #8

Derives from Tom's expanded patch #8, building on Michael's #6, with both credited in the commit. Additional edits initialize compression for built-in text and changed index types, reorder bootstrap initialization, clarify comments, and bump catversion.

Credits across 4 commits

Author
Michael Paquier1 LLM2
Tom LaneLLM2
Reviewer
Dilip Kumar1
Reported by
Andres Freund1
Committer
Michael Paquier2
Tom Lane2

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