model-writtenrun 7349 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Josef Šimánek proposed allowing HOT updates of BRIN-indexed columns in #1, using an index-AM flag and a separate HOT-blocking attribute bitmap, with a statistics-based regression test.
- After Josef reported an isolation-test failure in #2, Tomas Vondra traced it to missing expression and predicate attributes in #3, and Josef incorporated that fix in #4.
- Tomas reported check-world success and proposed simplifying the bitmaps in #5, but Alvaro Herrera explained in #10 that the bitmap describes all indexes of a table, so BRIN and ordinary indexes must remain distinguishable.
- Josef proposed replacing the otherwise-unused rd_indexattr bitmap with a validity boolean in #8, Alvaro supported removing the obsolete bitmap API in #12, and Josef reported finding no external usage in #15.
- After a gap, Tomas took over polishing in #16, supplying the complete series with the boolean replacement and missing bitmap initialization and cleanup, which Josef tested successfully in #17.
- Tomas demonstrated that changing a BRIN predicate column could incorrectly hide a row in #18, and revised the patch so predicate attributes always block HOT while adding AM documentation.
- Tomas landed that version as 5753d4ee32 with additional documentation, comments, and a predicate regression test, announcing the push in #19.
- In #19, Tomas left more selective predicate evaluation outside the patch because it would complicate cached attribute analysis and its performance trade-off was unclear.
- Justin Pryzby reported intermittent statistics-test failures and a comment typo in #21; Tom Lane initially recommended removing the test in #22, then suggested moving it to stats.sql in #24.
- Tomas implemented that relocation and typo correction in fe60b67250, preserving the test rather than deleting it.
- At the thread's last message, #25, the feature and test relocation had landed, while further relaxation of HOT rules and configurable ignoring of flaky statistics tests remained open ideas.
- Beyond the supplied messages, 19d8e2308b records that the original landing was reverted for correctness issues and restores the feature through work credited to Matthias van de Meent, Josef Simanek, and Tomas Vondra, explicitly updating summarizing indexes during HOT updates through TU_UpdateIndexes and adding regression coverage for changed BRIN bounds.
- The supplied attribution for thread #46025 identifies its March 2023 submission #530510 as the source of 19d8e2308b, with light final edits, replacing the previous attribution to this thread's older #18.