Aug 2024

1 commit
Remove incidental md5() function use from test
16 Aug 2024Peter Eisentrautmaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1REL_17_STABLE17rc1
LLM analysis, 100% surewritten from the discussion, no matching patch1 of 1 reviewer saw the final version

Implements Peter's inline md5-to-SHA256 replacement from #43 in contrib/pageinspect/sql/brin.sql and adjusts expected index page counts, as checked in #44.

  • Tomas Vondrasaw the final versiontrailerIn #44, Tomas reviewed the inline change from #43 and confirmed that longer summaries and the extra index page do not invalidate the test.

Apr 2024

7 commits
Cleanup parallel BRIN index build code
17 Apr 2024Tomas Vondramaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #39

The complete brin.c diff is identical to #39, introducing _brin_parallel_heapscan and _brin_parallel_merge; only the commit message was rewritten, as confirmed in #42.

Stabilize test of BRIN parallel create
17 Apr 2024Tomas Vondramaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1
LLM analysis, 100% surewritten from the discussion, no matching patch1 of 2 reviewers saw the final version

Replaces DELETE/VACUUM with partial-index predicates in contrib/pageinspect/sql/brin.sql and its expected output, implementing the stabilization described in #41 without a matching attached patchset. The commit credits Matthias's suggestion and Tomas's implementation.

  • Alexander Lakhinsaw an earlier versionLLM analysis, 90% sureAlexander reproduced intermittent failures in the tests from #35 and proposed temporary tables in #37, before the stabilization approach changed to partial-index predicates.
  • Matthias van de Meentsaw the final versionLLM analysis, 100% sureThe commit 0bd4b0689b credits Matthias's off-list suggestion to use partial indexes, which Tomas confirms adopting in #41.
Revert "Stabilize test of BRIN parallel create"
17 Apr 2024Tomas Vondramaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1reverts 1 commit here
LLM analysis, 100% surewritten from the discussion, no matching patch

Exactly reverses the temporary-table change after #40 explains that temporary tables disable parallel index builds; #41 confirms the revert.

Stabilize test of BRIN parallel create
16 Apr 2024Tomas Vondramaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1Also in: Unstable regression test for contrib/pageinspect
LLM analysis, 100% surewritten from the discussion, no matching patch1 of 1 reviewer saw the final version

Applies Alexander's inline proposal in #37 by making brin_parallel_test temporary in the SQL and expected output; the commit explicitly credits him as author.

  • Tomas Vondrasaw the final versioncommittercommitted the patch
Add regression test for BRIN parallel builds
14 Apr 2024Tomas Vondramaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1
LLM analysis, 96% surepart of a posted patchsetlight changesfrom patchset #350 of 1 reviewer saw the final version

Takes the pageinspect regression-test components of #35, comparing serial, parallel, and fallback builds across minmax, bloom, and minmax-multi opclasses. #36 reports reducing test data and checking 32-bit behavior; missing attachment contents prevent an exact comparison.

  • Andres Freundsaw an earlier versionLLM analysis, 86% sureAndres reported in #33 that coverage testing never exercised the landed parallel-build implementation from #28, prompting the new regression tests.
Use the correct PG_DETOAST_DATUM macro in BRIN
14 Apr 2024Tomas Vondramaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1REL_16_STABLE16.3
LLM analysis, 95% surepart of a posted patchsetlight changesfrom patchset #35

Extracts the detoasting fix described in #35, replacing PG_DETOAST_DATUM_PACKED in brin_bloom_summary_out and brin_minmax_multi_summary_out. #36 confirms that both fixes were committed and backpatched, although the original attachment is unavailable for exact comparison.

Update nbits_set in brin_bloom_union
14 Apr 2024Tomas Vondramaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1REL_16_STABLE16.3REL_15_STABLE15.7REL_14_STABLE14.12
LLM analysis, 95% surepart of a posted patchsetlight changesfrom patchset #35

Extracts the bloom-counter fix described in #35, recalculating nbits_set with pg_popcount after brin_bloom_union merges filters. Landing is confirmed in #36, but attachment extraction failed, limiting exact comparison.

Dec 2023

1 commit
Fix parallel BRIN builds with synchronized scans
30 Dec 2023Tomas Vondramaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1
LLM analysis, 100% surewritten from the discussion, no matching patch

No attached patch matches this fix: brinbuildCallbackParallel now detects both earlier and later ranges when synchronized scans wrap around, precisely the failure and remedy reported in #32.

Dec 2023

2 commits
Allow parallel CREATE INDEX for BRIN indexes
8 Dec 2023Tomas Vondramaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1
LLM analysis, 100% surepart of a posted patchsetmoderate changesfrom patchset #281 of 1 reviewer saw the final version

Lands the parallel-build portion of #28, including BRIN tuplesort support, amcanbuildparallel, and fallback cleanup, after extracting serial backfilling separately. Comparing the accumulated series with the landed code confirms comment cleanup, an empty-table boundary fix, and removal of overflow protection; the commit credits Tomas and Matthias as co-authors.

  • Matthias van de Meentsaw the final versiontrailerMatthias reviewed successive designs, supplied fixes, and reviewed the source submission in #29, identifying its empty-table underflow and accepting the empty-tuple lifetime fix.
Add empty BRIN ranges during CREATE INDEX
8 Dec 2023Tomas Vondramaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1
LLM analysis, 100% surepart of a posted patchsetmoderate changesfrom patchset #281 of 1 reviewer saw the final version

Extracts serial empty-range backfilling and shared helper changes from #28, with an empty-table boundary correction, deferred overflow checks, and an added pageinspect test. The commit explicitly credits Matthias, whose original backfilling patch appears in #27.

  • Tomas Vondrasaw the final versiontrailerTomas reviewed and reworked Matthias's backfilling in #28, added testing and cleanup described in #31, and committed the final version.

Credits across 11 commits

Author
Tomas Vondra4 LLM5
Matthias van de Meent2
Alexander Lakhin1
Reviewer
Tomas Vondracommitter3
Matthias van de Meent1
Committer
Tomas Vondra10
Peter Eisentraut1

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